Please wait...

OverviewTableDiagramViewProcedureFunctionTrigger

Create New Table

Tables

tblAuthors

tblResource

tblResourceContact

tblResourceType

Table tblResource

Comment: Save

Columns

Name	Data type	Not NULL	Primary key	Length	Decimals	Default	AutoInc	Comment
ResourceID	Int
Title	VarChar			250
Description	VarChar			250
AuthorID	Int
PublicationDate	DateTime
ResourceTypeID	Int
ResourceContactID	Int

Keys & Indexes

Name	Type	Columns
PK_ResourceID	Primary Key	ResourceID

Foreign Keys

Name	Base Table	Referenced Table	Columns
FK_AuthorID	tblResource	tblAuthors	AuthorID->AuthorID
FK_RsourceContactID	tblResource	tblResourceContact	ResourceContactID->ResourceContactID
FK_ResourceTypeID	tblResource	tblResourceType	ResourceTypeID->ResourceTypeID

Static Data

ResourceID	Title	Description	AuthorID	PublicationDate	ResourceTypeID	ResourceContactID

Name:
Data type:
Not NULL:
Primary key:
Length:
Decimals:
Default value:
Auto increment:
Comment:

Name:
On delete rule:
On update rule:
Child cardinality:
Child optionality:

Name:

Unique:

Schema:
Name:

Operation cannot be finished, because some limits are exceeded.

Object	Used	Added	Required	Limit