Toad Data Modeler - HTML Report

dbo.AspNetUsers.AccessFailedCount

General Info

Caption	AccessFailedCount
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.AspNetUsers.Active

General Info

Caption	Active
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	YES
Unique	NO
Default	((1))

dbo.AspNetUsers.Email

General Info

Caption	Email
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.AspNetUsers.EmailConfirmed

General Info

Caption	EmailConfirmed
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	YES
Unique	NO

dbo.AspNetUsers.FirstName

General Info

Caption	FirstName
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.AspNetUsers.Id

General Info

Caption	Id
Entity Name	dbo.AspNetUsers
Primary Key	YES
Foreign Key	NO
Data Type	Nvarchar(128)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.AspNetUsers.LastName

General Info

Caption	LastName
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.AspNetUsers.LockoutEnabled

General Info

Caption	LockoutEnabled
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	YES
Unique	NO

dbo.AspNetUsers.LockoutEndDateUtc

General Info

Caption	LockoutEndDateUtc
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.AspNetUsers.PasswordHash

General Info

Caption	PasswordHash
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.AspNetUsers.PhoneNumber

General Info

Caption	PhoneNumber
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.AspNetUsers.PhoneNumberConfirmed

General Info

Caption	PhoneNumberConfirmed
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	YES
Unique	NO

dbo.AspNetUsers.RoleName

General Info

Caption	RoleName
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Computed Column
Not Null	NO
Unique	NO

Attribute Properties

Computed Column Expression

([dbo].[fGetRoleName]([Id]))

dbo.AspNetUsers.SecurityStamp

General Info

Caption	SecurityStamp
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.AspNetUsers.TwoFactorEnabled

General Info

Caption	TwoFactorEnabled
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	YES
Unique	NO

dbo.AspNetUsers.UserName

General Info

Caption	UserName
Entity Name	dbo.AspNetUsers
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.address

General Info

Caption	address
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.advance_count

General Info

Caption	advance_count
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.competition.code

General Info

Caption	code
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(12)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.competition.date_from

General Info

Caption	date_from
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.competition.date_to

General Info

Caption	date_to
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.competition.dlouhodobe_kratkodobe

General Info

Caption	dlouhodobe_kratkodobe
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.elo_cz

General Info

Caption	elo_cz
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	NO
Unique	NO

dbo.competition.elo_international

General Info

Caption	elo_international
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	NO
Unique	NO

dbo.competition.email

General Info

Caption	email
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.id_competition

General Info

Caption	id_competition
Entity Name	dbo.competition
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.competition.id_competition_type

General Info

Caption	id_competition_type
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.id_kraj

General Info

Caption	id_kraj
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.id_level

General Info

Caption	id_level
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.id_man_player

General Info

Caption	id_man_player
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.id_type

General Info

Caption	id_type
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.id_young_or_adult

General Info

Caption	id_young_or_adult
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.lost

General Info

Caption	lost
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO
Default	((0))

dbo.competition.phone

General Info

Caption	phone
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.players

General Info

Caption	players
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.competition.regress_count

General Info

Caption	regress_count
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.remi

General Info

Caption	remi
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO
Default	((1))

dbo.competition.sid

General Info

Caption	sid
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition.svaz

General Info

Caption	svaz
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.competition.teams

General Info

Caption	teams
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.competition.title

General Info

Caption	title
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(120)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.wins

General Info

Caption	wins
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO
Default	((3))

dbo.competition.www

General Info

Caption	www
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition.year

General Info

Caption	year
Entity Name	dbo.competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.competition_rating.id_competition

General Info

Caption	id_competition
Entity Name	dbo.competition_rating
Primary Key	YES
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.competition_rating.id_competition_rating

General Info

Caption	id_competition_rating
Entity Name	dbo.competition_rating
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.competition_rating.id_rating

General Info

Caption	id_rating
Entity Name	dbo.competition_rating
Primary Key	YES
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.competition_rating.valid_from

General Info

Caption	valid_from
Entity Name	dbo.competition_rating
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.competition_rating.valid_to

General Info

Caption	valid_to
Entity Name	dbo.competition_rating
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.competition_type.code

General Info

Caption	code
Entity Name	dbo.competition_type
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(15)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.competition_type.id_competition_type

General Info

Caption	id_competition_type
Entity Name	dbo.competition_type
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.elo.id_elo

General Info

Caption	id_elo
Entity Name	dbo.elo
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.elo.title

General Info

Caption	title
Entity Name	dbo.elo
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.file_competition.Guid

General Info

Caption	Guid
Entity Name	dbo.file_competition
Primary Key	NO
Foreign Key	NO
Data Type	Uniqueidentifier
Not Null	YES
Unique	NO
Default	NEWID()

dbo.file_competition.id_competition

General Info

Caption	id_competition
Entity Name	dbo.file_competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.file_competition.id_file_competition

General Info

Caption	id_file_competition
Entity Name	dbo.file_competition
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.file_competition.import_date

General Info

Caption	import_date
Entity Name	dbo.file_competition
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.file_competition.name

General Info

Caption	name
Entity Name	dbo.file_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.file_competition.path

General Info

Caption	path
Entity Name	dbo.file_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.file_game.Guid

General Info

Caption	Guid
Entity Name	dbo.file_game
Primary Key	NO
Foreign Key	NO
Data Type	Uniqueidentifier
Not Null	YES
Unique	NO
Default	NEWID()

dbo.file_game.id_file_game

General Info

Caption	id_file_game
Entity Name	dbo.file_game
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.file_game.id_game

General Info

Caption	id_game
Entity Name	dbo.file_game
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.file_game.import_date

General Info

Caption	import_date
Entity Name	dbo.file_game
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.file_game.name

General Info

Caption	name
Entity Name	dbo.file_game
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.file_game.path

General Info

Caption	path
Entity Name	dbo.file_game
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.game.board

General Info

Caption	board
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.game.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.game.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.game.forfeited

General Info

Caption	forfeited
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	YES
Unique	NO
Default	0

dbo.game.id_game

General Info

Caption	id_game
Entity Name	dbo.game
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.game.id_match

General Info

Caption	id_match
Entity Name	dbo.game
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.game.id_player_team1

General Info

Caption	id_player_team1
Entity Name	dbo.game
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.game.id_player_team2

General Info

Caption	id_player_team2
Entity Name	dbo.game
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.game.round_no

General Info

Caption	round_no
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.game.scr1

General Info

Caption	scr1
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	YES
Unique	NO
Default	((0.0))

dbo.game.scr1_corrected

General Info

Caption	scr1_corrected
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.game.scr2

General Info

Caption	scr2
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	YES
Unique	NO
Default	((0.0))

dbo.game.scr2_corrected

General Info

Caption	scr2_corrected
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.game.sid

General Info

Caption	sid
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.game.tno1

General Info

Caption	tno1
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.game.tno2

General Info

Caption	tno2
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.game.type

General Info

Caption	type
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.game.year

General Info

Caption	year
Entity Name	dbo.game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.import.createDate

General Info

Caption	createDate
Entity Name	dbo.import
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.import.filename

General Info

Caption	filename
Entity Name	dbo.import
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import.ImportId

General Info

Caption	ImportId
Entity Name	dbo.import
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import.success

General Info

Caption	success
Entity Name	dbo.import
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	NO
Unique	NO

dbo.import_hrac.birthday

General Info

Caption	birthday
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.import_hrac.comment

General Info

Caption	comment
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.datum

General Info

Caption	datum
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.import_hrac.elo_cr

General Info

Caption	elo_cr
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.elo_cr_online

General Info

Caption	elo_cr_online
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.elo_fide

General Info

Caption	elo_fide
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.elo_fide_blesk

General Info

Caption	elo_fide_blesk
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.elo_fide_rapid

General Info

Caption	elo_fide_rapid
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.elo_rapid

General Info

Caption	elo_rapid
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.email

General Info

Caption	email
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.fide_nr

General Info

Caption	fide_nr
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.gender

General Info

Caption	gender
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	NO
Unique	NO

dbo.import_hrac.id_import_hrac

General Info

Caption	id_import_hrac
Entity Name	dbo.import_hrac
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_hrac.id_player

General Info

Caption	id_player
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.importid

General Info

Caption	importid
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.kod

General Info

Caption	kod
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.name

General Info

Caption	name
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.oddil

General Info

Caption	oddil
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_hrac.phone

General Info

Caption	phone
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.phonefirm

General Info

Caption	phonefirm
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.phonemobil

General Info

Caption	phonemobil
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.platnost

General Info

Caption	platnost
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.rc

General Info

Caption	rc
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.referee

General Info

Caption	referee
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.registration_date

General Info

Caption	registration_date
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.import_hrac.roknar

General Info

Caption	roknar
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.rplatnost

General Info

Caption	rplatnost
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.state

General Info

Caption	state
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.title

General Info

Caption	title
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.tplatnost

General Info

Caption	tplatnost
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.trainer

General Info

Caption	trainer
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.ulice

General Info

Caption	ulice
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.vt

General Info

Caption	vt
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(10)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_hrac.zipcode

General Info

Caption	zipcode
Entity Name	dbo.import_hrac
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_oddil.code

General Info

Caption	code
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(5)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_oddil.email

General Info

Caption	email
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_oddil.id_import_oddil

General Info

Caption	id_import_oddil
Entity Name	dbo.import_oddil
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_oddil.id_oddil

General Info

Caption	id_oddil
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.import_oddil.ImportId

General Info

Caption	ImportId
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_oddil.kod

General Info

Caption	kod
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(3)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_oddil.kontakt_player

General Info

Caption	kontakt_player
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_oddil.kraj

General Info

Caption	kraj
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_oddil.name

General Info

Caption	name
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_oddil.okres

General Info

Caption	okres
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_oddil.region

General Info

Caption	region
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_oddil.type

General Info

Caption	type
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_oddil.valid

General Info

Caption	valid
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	NO
Unique	NO

dbo.import_oddil.www

General Info

Caption	www
Entity Name	dbo.import_oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_competition.id_import_vysledky_competition

General Info

Caption	id_import_vysledky_competition
Entity Name	dbo.import_vysledky_competition
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_vysledky_competition.ImportId

General Info

Caption	ImportId
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_address

General Info

Caption	soutez_address
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_competition.soutez_code

General Info

Caption	soutez_code
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(15)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_competition.soutez_email

General Info

Caption	soutez_email
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_competition.soutez_id

General Info

Caption	soutez_id
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_lost

General Info

Caption	soutez_lost
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_man

General Info

Caption	soutez_man
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_phone

General Info

Caption	soutez_phone
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_competition.soutez_players

General Info

Caption	soutez_players
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_remi

General Info

Caption	soutez_remi
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_teams

General Info

Caption	soutez_teams
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_title

General Info

Caption	soutez_title
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(120)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_competition.soutez_wins

General Info

Caption	soutez_wins
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_competition.soutez_www

General Info

Caption	soutez_www
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_competition.soutez_year

General Info

Caption	soutez_year
Entity Name	dbo.import_vysledky_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_game.board1

General Info

Caption	board1
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_game.board2

General Info

Caption	board2
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_game.id_import_vysledky_game

General Info

Caption	id_import_vysledky_game
Entity Name	dbo.import_vysledky_game
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_vysledky_game.importId

General Info

Caption	importId
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_game.no

General Info

Caption	no
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_game.result_id

General Info

Caption	result_id
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(4)
Not Null	NO
Unique	NO

dbo.import_vysledky_game.scr1

General Info

Caption	scr1
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.import_vysledky_game.scr2

General Info

Caption	scr2
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.import_vysledky_game.soutez_id

General Info

Caption	soutez_id
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_game.type

General Info

Caption	type
Entity Name	dbo.import_vysledky_game
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.board

General Info

Caption	board
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_list.code

General Info

Caption	code
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.cr

General Info

Caption	cr
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_list.elo

General Info

Caption	elo
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.elo_all

General Info

Caption	elo_all
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.fide

General Info

Caption	fide
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_list.id_import_vysledky_list

General Info

Caption	id_import_vysledky_list
Entity Name	dbo.import_vysledky_list
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_vysledky_list.ImportId

General Info

Caption	ImportId
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_list.memo

General Info

Caption	memo
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.name

General Info

Caption	name
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.played

General Info

Caption	played
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.played_all

General Info

Caption	played_all
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.pnt

General Info

Caption	pnt
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.pnt_all

General Info

Caption	pnt_all
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.soutez_id

General Info

Caption	soutez_id
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_list.sumelo

General Info

Caption	sumelo
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.sumelo_all

General Info

Caption	sumelo_all
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_list.tno

General Info

Caption	tno
Entity Name	dbo.import_vysledky_list
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_results.id_import_vysledky_results

General Info

Caption	id_import_vysledky_results
Entity Name	dbo.import_vysledky_results
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_vysledky_results.importId

General Info

Caption	importId
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_results.no

General Info

Caption	no
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_results.note

General Info

Caption	note
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_results.scr1

General Info

Caption	scr1
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.import_vysledky_results.scr2

General Info

Caption	scr2
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.import_vysledky_results.soutez_id

General Info

Caption	soutez_id
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_results.tno1

General Info

Caption	tno1
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_results.tno2

General Info

Caption	tno2
Entity Name	dbo.import_vysledky_results
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_round.id_import_vysledky_round

General Info

Caption	id_import_vysledky_round
Entity Name	dbo.import_vysledky_round
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_vysledky_round.importId

General Info

Caption	importId
Entity Name	dbo.import_vysledky_round
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_round.no

General Info

Caption	no
Entity Name	dbo.import_vysledky_round
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_round.schedule

General Info

Caption	schedule
Entity Name	dbo.import_vysledky_round
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_round.soutez_id

General Info

Caption	soutez_id
Entity Name	dbo.import_vysledky_round
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_round.term

General Info

Caption	term
Entity Name	dbo.import_vysledky_round
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.import_vysledky_team.id_import_vysledky_team

General Info

Caption	id_import_vysledky_team
Entity Name	dbo.import_vysledky_team
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.import_vysledky_team.importId

General Info

Caption	importId
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.soutez_id

General Info

Caption	soutez_id
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_draw

General Info

Caption	team_draw
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_lose

General Info

Caption	team_lose
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_m1

General Info

Caption	team_m1
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_m2

General Info

Caption	team_m2
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_m3

General Info

Caption	team_m3
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_man1

General Info

Caption	team_man1
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_team.team_man2

General Info

Caption	team_man2
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_team.team_man3

General Info

Caption	team_man3
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_team.team_no

General Info

Caption	team_no
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_note

General Info

Caption	team_note
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_team.team_play

General Info

Caption	team_play
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_pt

General Info

Caption	team_pt
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_scr

General Info

Caption	team_scr
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(5,1)
Not Null	NO
Unique	NO

dbo.import_vysledky_team.team_title

General Info

Caption	team_title
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(40)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.import_vysledky_team.team_win

General Info

Caption	team_win
Entity Name	dbo.import_vysledky_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.kraj.code

General Info

Caption	code
Entity Name	dbo.kraj
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(5)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.kraj.id_kraj

General Info

Caption	id_kraj
Entity Name	dbo.kraj
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.kraj.name

General Info

Caption	name
Entity Name	dbo.kraj
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.kraj.region

General Info

Caption	region
Entity Name	dbo.kraj
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.level.id_level

General Info

Caption	id_level
Entity Name	dbo.level
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.level.title

General Info

Caption	title
Entity Name	dbo.level
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO
Default	(NULL)

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.match.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.match.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.match.datetime_match

General Info

Caption	datetime_match
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.match.id_match

General Info

Caption	id_match
Entity Name	dbo.match
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.match.id_referee

General Info

Caption	id_referee
Entity Name	dbo.match
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.match.id_round

General Info

Caption	id_round
Entity Name	dbo.match
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.match.id_team_competition1

General Info

Caption	id_team_competition1
Entity Name	dbo.match
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.match.id_team_competition2

General Info

Caption	id_team_competition2
Entity Name	dbo.match
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.match.no

General Info

Caption	no
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.match.note

General Info

Caption	note
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.match.scr1

General Info

Caption	scr1
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.match.scr2

General Info

Caption	scr2
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(3,1)
Not Null	NO
Unique	NO

dbo.match.sid

General Info

Caption	sid
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.match.site

General Info

Caption	site
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.match.tno1

General Info

Caption	tno1
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.match.tno2

General Info

Caption	tno2
Entity Name	dbo.match
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.material.id_material

General Info

Caption	id_material
Entity Name	dbo.material
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.material.name

General Info

Caption	name
Entity Name	dbo.material
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.material.type

General Info

Caption	type
Entity Name	dbo.material
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.material_vyuka.id_material

General Info

Caption	id_material
Entity Name	dbo.material_vyuka
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.material_vyuka.id_material_vyuka

General Info

Caption	id_material_vyuka
Entity Name	dbo.material_vyuka
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.material_vyuka.id_vyuka

General Info

Caption	id_vyuka
Entity Name	dbo.material_vyuka
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.oddil.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.oddil.code

General Info

Caption	code
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(5)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.oddil.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.oddil.email

General Info

Caption	email
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.oddil.id_kontakt_player

General Info

Caption	id_kontakt_player
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.oddil.id_oddil

General Info

Caption	id_oddil
Entity Name	dbo.oddil
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.oddil.id_okres

General Info

Caption	id_okres
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.oddil.id_region

General Info

Caption	id_region
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.oddil.kod

General Info

Caption	kod
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(3)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.oddil.name

General Info

Caption	name
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(40)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.oddil.type

General Info

Caption	type
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.oddil.valid

General Info

Caption	valid
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Bit
Not Null	NO
Unique	NO

dbo.oddil.www

General Info

Caption	www
Entity Name	dbo.oddil
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.oddil_player.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.oddil_player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.oddil_player.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.oddil_player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.oddil_player.date_from

General Info

Caption	date_from
Entity Name	dbo.oddil_player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.oddil_player.date_to

General Info

Caption	date_to
Entity Name	dbo.oddil_player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.oddil_player.id_oddil

General Info

Caption	id_oddil
Entity Name	dbo.oddil_player
Primary Key	YES
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.oddil_player.id_oddil_player

General Info

Caption	id_oddil_player
Entity Name	dbo.oddil_player
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.oddil_player.id_player

General Info

Caption	id_player
Entity Name	dbo.oddil_player
Primary Key	YES
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.okres.id_kraj

General Info

Caption	id_kraj
Entity Name	dbo.okres
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.okres.id_okres

General Info

Caption	id_okres
Entity Name	dbo.okres
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.okres.name

General Info

Caption	name
Entity Name	dbo.okres
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(19)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.adult_from

General Info

Caption	adult_from
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.birth_country

General Info

Caption	birth_country
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.birthday

General Info

Caption	birthday
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.city

General Info

Caption	city
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.code

General Info

Caption	code
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.comment

General Info

Caption	comment
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.ELO_N

General Info

Caption	ELO_N
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.ELO_ONLINE

General Info

Caption	ELO_ONLINE
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.ELO_RAPID

General Info

Caption	ELO_RAPID
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.email

General Info

Caption	email
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(256)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.FIDE

General Info

Caption	FIDE
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.FIDE_BLESK

General Info

Caption	FIDE_BLESK
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.fide_nr

General Info

Caption	fide_nr
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.FIDE_RAPID

General Info

Caption	FIDE_RAPID
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.firstname

General Info

Caption	firstname
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.gender

General Info

Caption	gender
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.id_player

General Info

Caption	id_player
Entity Name	dbo.player
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.player.id_referee_typ

General Info

Caption	id_referee_typ
Entity Name	dbo.player
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.id_state

General Info

Caption	id_state
Entity Name	dbo.player
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.id_trainer_typ

General Info

Caption	id_trainer_typ
Entity Name	dbo.player
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.id_young_or_adult

General Info

Caption	id_young_or_adult
Entity Name	dbo.player
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.player.phone

General Info

Caption	phone
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.phonefirm

General Info

Caption	phonefirm
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.phonemobil

General Info

Caption	phonemobil
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.rc

General Info

Caption	rc
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.registration_date

General Info

Caption	registration_date
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.rplatnost

General Info

Caption	rplatnost
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.street

General Info

Caption	street
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.surname

General Info

Caption	surname
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.title

General Info

Caption	title
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.tplatnost

General Info

Caption	tplatnost
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.unregistration_date

General Info

Caption	unregistration_date
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player.vt

General Info

Caption	vt
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(10)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player.zipcode

General Info

Caption	zipcode
Entity Name	dbo.player
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player_elo.date_elo

General Info

Caption	date_elo
Entity Name	dbo.player_elo
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player_elo.elo

General Info

Caption	elo
Entity Name	dbo.player_elo
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.player_elo.id_elo

General Info

Caption	id_elo
Entity Name	dbo.player_elo
Primary Key	YES
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.player_elo.id_elo_player

General Info

Caption	id_elo_player
Entity Name	dbo.player_elo
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.player_elo.id_player

General Info

Caption	id_player
Entity Name	dbo.player_elo
Primary Key	YES
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.player_elo.value

General Info

Caption	value
Entity Name	dbo.player_elo
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.board

General Info

Caption	board
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player_team.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player_team.date_from

General Info

Caption	date_from
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player_team.date_to

General Info

Caption	date_to
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.player_team.id_player

General Info

Caption	id_player
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.player_team.id_player_team

General Info

Caption	id_player_team
Entity Name	dbo.player_team
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.player_team.id_team_competition

General Info

Caption	id_team_competition
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_c

General Info

Caption	player_c
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_d

General Info

Caption	player_d
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_h

General Info

Caption	player_h
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_k

General Info

Caption	player_k
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_m

General Info

Caption	player_m
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_v

General Info

Caption	player_v
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_z

General Info

Caption	player_z
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.player_team.player_zk

General Info

Caption	player_zk
Entity Name	dbo.player_team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.rating.condition

General Info

Caption	condition
Entity Name	dbo.rating
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.rating.id_rating

General Info

Caption	id_rating
Entity Name	dbo.rating
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.rating.name

General Info

Caption	name
Entity Name	dbo.rating
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.referee_typ.code

General Info

Caption	code
Entity Name	dbo.referee_typ
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.referee_typ.id_referee_typ

General Info

Caption	id_referee_typ
Entity Name	dbo.referee_typ
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.referee_typ.name

General Info

Caption	name
Entity Name	dbo.referee_typ
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.region.code

General Info

Caption	code
Entity Name	dbo.region
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(10)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.region.id_region

General Info

Caption	id_region
Entity Name	dbo.region
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.region.name

General Info

Caption	name
Entity Name	dbo.region
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(30)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.round.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.round
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.round.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.round
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.round.id_competition

General Info

Caption	id_competition
Entity Name	dbo.round
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.round.id_round

General Info

Caption	id_round
Entity Name	dbo.round
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.round.no

General Info

Caption	no
Entity Name	dbo.round
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.round.sid

General Info

Caption	sid
Entity Name	dbo.round
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.round.term

General Info

Caption	term
Entity Name	dbo.round
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.school.city

General Info

Caption	city
Entity Name	dbo.school
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.school.id_kraj

General Info

Caption	id_kraj
Entity Name	dbo.school
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.school.id_school

General Info

Caption	id_school
Entity Name	dbo.school
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.school.name

General Info

Caption	name
Entity Name	dbo.school
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.school.psc

General Info

Caption	psc
Entity Name	dbo.school
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(10)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.school.strees

General Info

Caption	strees
Entity Name	dbo.school
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.state.code

General Info

Caption	code
Entity Name	dbo.state
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.state.fee

General Info

Caption	fee
Entity Name	dbo.state
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.state.id_state

General Info

Caption	id_state
Entity Name	dbo.state
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.state.name

General Info

Caption	name
Entity Name	dbo.state
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student.city

General Info

Caption	city
Entity Name	dbo.student
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student.email

General Info

Caption	email
Entity Name	dbo.student
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(100)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student.firstname

General Info

Caption	firstname
Entity Name	dbo.student
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student.id_player

General Info

Caption	id_player
Entity Name	dbo.student
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.student.id_student

General Info

Caption	id_student
Entity Name	dbo.student
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.student.lastname

General Info

Caption	lastname
Entity Name	dbo.student
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student.phone

General Info

Caption	phone
Entity Name	dbo.student
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student.psc

General Info

Caption	psc
Entity Name	dbo.student
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(10)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student.street

General Info

Caption	street
Entity Name	dbo.student
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.student_vyuka.id_student

General Info

Caption	id_student
Entity Name	dbo.student_vyuka
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.student_vyuka.id_student_vyuka

General Info

Caption	id_student_vyuka
Entity Name	dbo.student_vyuka
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.student_vyuka.id_vyuka

General Info

Caption	id_vyuka
Entity Name	dbo.student_vyuka
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.team.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.team.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.team.id_oddil

General Info

Caption	id_oddil
Entity Name	dbo.team
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.team.id_team

General Info

Caption	id_team
Entity Name	dbo.team
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.team.id_team_old

General Info

Caption	id_team_old
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team.no

General Info

Caption	no
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.team.note

General Info

Caption	note
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.team.room

General Info

Caption	room
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.team.sid

General Info

Caption	sid
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team.title

General Info

Caption	title
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(40)
Not Null	YES
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.team.v1

General Info

Caption	v1
Entity Name	dbo.team
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.team.v1_text

General Info

Caption	v1_text
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.team.v2

General Info

Caption	v2
Entity Name	dbo.team
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.team.v2_text

General Info

Caption	v2_text
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.team.v3

General Info

Caption	v3
Entity Name	dbo.team
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.team.v3_text

General Info

Caption	v3_text
Entity Name	dbo.team
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(max)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.team_competition.ChangeDate

General Info

Caption	ChangeDate
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.team_competition.CreateDate

General Info

Caption	CreateDate
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.team_competition.draw

General Info

Caption	draw
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.id_competition

General Info

Caption	id_competition
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.team_competition.id_team

General Info

Caption	id_team
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	YES
Unique	NO

dbo.team_competition.id_team_competition

General Info

Caption	id_team_competition
Entity Name	dbo.team_competition
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.team_competition.id_team_old

General Info

Caption	id_team_old
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.lose

General Info

Caption	lose
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.pt

General Info

Caption	pt
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.scr

General Info

Caption	scr
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Decimal(5,1)
Not Null	NO
Unique	NO

dbo.team_competition.sid

General Info

Caption	sid
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.team_score_average

General Info

Caption	team_score_average
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.tno

General Info

Caption	tno
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.wga

General Info

Caption	wga
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.team_competition.win

General Info

Caption	win
Entity Name	dbo.team_competition
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.term.id_round

General Info

Caption	id_round
Entity Name	dbo.term
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.term.id_team_competition1

General Info

Caption	id_team_competition1
Entity Name	dbo.term
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.term.id_team_competition2

General Info

Caption	id_team_competition2
Entity Name	dbo.term
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.term.id_term

General Info

Caption	id_term
Entity Name	dbo.term
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.term.no

General Info

Caption	no
Entity Name	dbo.term
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.term.sid

General Info

Caption	sid
Entity Name	dbo.term
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.term.term_date

General Info

Caption	term_date
Entity Name	dbo.term
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.term.tno1

General Info

Caption	tno1
Entity Name	dbo.term
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.term.tno2

General Info

Caption	tno2
Entity Name	dbo.term
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.trainer_typ.code

General Info

Caption	code
Entity Name	dbo.trainer_typ
Primary Key	NO
Foreign Key	NO
Data Type	Nchar(1)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.trainer_typ.id_trainer_typ

General Info

Caption	id_trainer_typ
Entity Name	dbo.trainer_typ
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.trainer_typ.name

General Info

Caption	name
Entity Name	dbo.trainer_typ
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.type.id_type

General Info

Caption	id_type
Entity Name	dbo.type
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.type.rnd

General Info

Caption	rnd
Entity Name	dbo.type
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.type.title

General Info

Caption	title
Entity Name	dbo.type
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.UserCompetition.id_competition

General Info

Caption	id_competition
Entity Name	dbo.UserCompetition
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.UserCompetition.id_user

General Info

Caption	id_user
Entity Name	dbo.UserCompetition
Primary Key	NO
Foreign Key	YES
Data Type	Nvarchar(128)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.UserCompetition.id_UserCompetition

General Info

Caption	id_UserCompetition
Entity Name	dbo.UserCompetition
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.vyuka.date

General Info

Caption	date
Entity Name	dbo.vyuka
Primary Key	NO
Foreign Key	NO
Data Type	Datetime
Not Null	NO
Unique	NO

dbo.vyuka.from

General Info

Caption	from
Entity Name	dbo.vyuka
Primary Key	NO
Foreign Key	NO
Data Type	Time(7)
Not Null	NO
Unique	NO

dbo.vyuka.id_contact_person

General Info

Caption	id_contact_person
Entity Name	dbo.vyuka
Primary Key	NO
Foreign Key	NO
Data Type	Int
Not Null	NO
Unique	NO

dbo.vyuka.id_school

General Info

Caption	id_school
Entity Name	dbo.vyuka
Primary Key	NO
Foreign Key	YES
Data Type	Int
Not Null	NO
Unique	NO

dbo.vyuka.id_vyuka

General Info

Caption	id_vyuka
Entity Name	dbo.vyuka
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

Attribute Properties

Identity	YES
Identity Seed	1
Identity Increment	1

dbo.vyuka.room

General Info

Caption	room
Entity Name	dbo.vyuka
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(255)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.vyuka.till

General Info

Caption	till
Entity Name	dbo.vyuka
Primary Key	NO
Foreign Key	NO
Data Type	Time(7)
Not Null	NO
Unique	NO

dbo.vyuka.type

General Info

Caption	type
Entity Name	dbo.vyuka
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(50)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS

dbo.young_or_adult.id_young_or_adult

General Info

Caption	id_young_or_adult
Entity Name	dbo.young_or_adult
Primary Key	YES
Foreign Key	NO
Data Type	Int
Not Null	YES
Unique	NO

dbo.young_or_adult.name

General Info

Caption	name
Entity Name	dbo.young_or_adult
Primary Key	NO
Foreign Key	NO
Data Type	Nvarchar(20)
Not Null	NO
Unique	NO

Attribute Properties

Collation For the Column

SQL_Latin1_General_CP1_CI_AS