Please wait...
Online Data Modeler

Table tblResource

Comment:

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

ResourceIDTitleDescriptionAuthorIDPublicationDateResourceTypeIDResourceContactID
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