ljamal_dbGCD |
gcdCharacter | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CharacterID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
NamePrefixID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
NameSuffixID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
intYearCreation |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
strNameFamily |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
strNameGiven |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
strDisambiguation |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dteTimeStamp |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
dteLastUpdate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdCharacter |
0 |
PRIMARY |
1 |
CharacterID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdCharacter |
1 |
FK_gcdCharacter1 |
1 |
NamePrefixID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
gcdCharacter |
1 |
FK_gcdCharacter2 |
1 |
NameSuffixID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdCharacter2 |
supNameSuffix |
`NameSuffixID` |
`NameSuffixID` |
|
FK_gcdCharacter1 |
supNamePrefix |
`NamePrefixID` |
`NamePrefixID` |
|
gcdContent | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ContentID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ColorTypeID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
ContentTypeID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
IssueID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
PaperStockID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
intPageCount |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intSortOrder |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
strTitle |
varchar(255) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtCharacter |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
txtSynopsis |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
dteTimeStamp |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
dteLastUpdate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdContent |
0 |
PRIMARY |
1 |
ContentID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContent |
1 |
FK_gcdContent |
1 |
ColorTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContent |
1 |
FK_gcdContent2 |
1 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContent |
1 |
FK_gcdContent3 |
1 |
ContentTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContent |
1 |
FK_gcdContent4 |
1 |
PaperStockID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdContent |
supColorType |
`ColorTypeID` |
`ColorTypeID` |
|
FK_gcdContent2 |
gcdIssue |
`IssueID` |
`IssueID` |
|
FK_gcdContent3 |
supContentType |
`ContentTypeID` |
`ContentTypeID` |
|
FK_gcdContent4 |
supPaperStock |
`PaperStockID` |
`PaperStockID` |
|
gcdContentCharacter | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ContentID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CharacterID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CharacterAliasID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
CharacterAppearanceID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CharacterGroupID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdContentCharacter |
0 |
PRIMARY |
1 |
ContentID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCharacter |
0 |
PRIMARY |
2 |
CharacterID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCharacter |
0 |
PRIMARY |
3 |
CharacterAppearanceID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCharacter |
1 |
FK_gcdContentCharacter |
1 |
CharacterID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCharacter |
1 |
FK_gcdContentCharacter2 |
1 |
CharacterAliasID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
gcdContentCharacter |
1 |
FK_gcdContentCharacter3 |
1 |
CharacterGroupID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
gcdContentCharacter |
1 |
FK_gcdContentCharacter4 |
1 |
CharacterAppearanceID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdContentCharacter |
gcdCharacter |
`CharacterID` |
`CharacterID` |
|
FK_gcdContentCharacter2 |
gcdCharacter |
`CharacterAliasID` |
`CharacterID` |
|
FK_gcdContentCharacter3 |
gcdCharacter |
`CharacterGroupID` |
`CharacterID` |
|
FK_gcdContentCharacter4 |
supCharacterAppearance |
`CharacterAppearanceID` |
`CharacterAppearanceID` |
|
FK_gcdContentCharacter5 |
gcdContent |
`ContentID` |
`ContentID` |
|
gcdContentCreatorRole | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ContentID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CreatorID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CreatorAliasID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
CreatorGroupID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
CreatorRoleID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CreatorRoleFlagID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
txtNote |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdContentCreatorRole |
0 |
PRIMARY |
1 |
ContentID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCreatorRole |
0 |
PRIMARY |
2 |
CreatorID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCreatorRole |
0 |
PRIMARY |
3 |
CreatorRoleID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCreatorRole |
1 |
FK_gcdContentCreatorRole2 |
1 |
CreatorAliasID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
gcdContentCreatorRole |
1 |
FK_gcdContentCreatorRole3 |
1 |
CreatorGroupID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
gcdContentCreatorRole |
1 |
FK_gcdContentCreatorRole4 |
1 |
CreatorID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCreatorRole |
1 |
FK_gcdContentCreatorRole5 |
1 |
CreatorRoleID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentCreatorRole |
1 |
FK_gcdContentCreatorRole6 |
1 |
CreatorRoleFlagID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdContentCreatorRole |
gcdContent |
`ContentID` |
`ContentID` |
|
FK_gcdContentCreatorRole2 |
gcdCreator |
`CreatorAliasID` |
`CreatorID` |
|
FK_gcdContentCreatorRole3 |
gcdCreator |
`CreatorGroupID` |
`CreatorID` |
|
FK_gcdContentCreatorRole4 |
gcdCreator |
`CreatorID` |
`CreatorID` |
|
FK_gcdContentCreatorRole5 |
supCreatorRole |
`CreatorRoleID` |
`CreatorRoleID` |
|
FK_gcdContentCreatorRole6 |
supCreatorRoleFlag |
`CreatorRoleFlagID` |
`CreatorRoleFlagID` |
|
gcdContentFeature | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ContentID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
FeatureID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdContentFeature |
0 |
PRIMARY |
1 |
ContentID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentFeature |
0 |
PRIMARY |
2 |
FeatureID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentFeature |
1 |
FK_gcdContentFeature |
1 |
FeatureID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdContentFeature |
gcdFeature |
`FeatureID` |
`FeatureID` |
|
FK_gcdContentFeature2 |
gcdContent |
`ContentID` |
`ContentID` |
|
gcdContentGenre | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ContentID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
GenreID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdContentGenre |
0 |
PRIMARY |
1 |
ContentID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentGenre |
0 |
PRIMARY |
2 |
GenreID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentGenre |
1 |
FK_gcdContentGenre2 |
1 |
GenreID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdContentGenre |
gcdContent |
`ContentID` |
`ContentID` |
|
FK_gcdContentGenre2 |
gcdGenre |
`GenreID` |
`GenreID` |
|
gcdContentJobCode | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
JobCodeID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
ContentID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
strJobCode |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdContentJobCode |
0 |
PRIMARY |
1 |
JobCodeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentJobCode |
1 |
FK_gcdContentJobCode |
1 |
ContentID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdContentJobCode |
gcdContent |
`ContentID` |
`ContentID` |
|
gcdContentReprint | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ContentID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
ReprintID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdContentReprint |
0 |
PRIMARY |
1 |
ContentID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentReprint |
0 |
PRIMARY |
2 |
ReprintID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdContentReprint |
1 |
FK_gcdContentReprint2 |
1 |
ReprintID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdContentReprint |
gcdContent |
`ContentID` |
`ContentID` |
|
FK_gcdContentReprint2 |
gcdContent |
`ReprintID` |
`ContentID` |
|
gcdCreator | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CreatorID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
NamePrefixID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
NameSuffixID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
boolNameStyle |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intBirthDay |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
intBirthMonth |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
intBirthYear |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
strNameFamily |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
strNameGiven |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dteTimeStamp |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
dteLastUpdate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdCreator |
0 |
PRIMARY |
1 |
CreatorID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdCreator |
1 |
FK_gcdCreator1 |
1 |
NamePrefixID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
gcdCreator |
1 |
FK_gcdCreator |
1 |
NameSuffixID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdCreator |
supNameSuffix |
`NameSuffixID` |
`NameSuffixID` |
|
FK_gcdCreator1 |
supNamePrefix |
`NamePrefixID` |
`NamePrefixID` |
|
gcdCreatortoCreator | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CreatorID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CreatorToID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CreatorRelationshipID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdCreatortoCreator |
0 |
PRIMARY |
1 |
CreatorID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdCreatortoCreator |
0 |
PRIMARY |
2 |
CreatorToID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdCreatortoCreator |
0 |
PRIMARY |
3 |
CreatorRelationshipID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdCreatortoCreator |
1 |
FK_gcdCreatortoCreator2 |
1 |
CreatorToID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdCreatortoCreator |
1 |
FK_gcdCreatortoCreator3 |
1 |
CreatorRelationshipID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdCreatortoCreator |
gcdCreator |
`CreatorID` |
`CreatorID` |
|
FK_gcdCreatortoCreator2 |
gcdCreator |
`CreatorToID` |
`CreatorID` |
|
FK_gcdCreatortoCreator3 |
supCreatorRelationship |
`CreatorRelationshipID` |
`CreatorRelationshipID` |
|
gcdFeature | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
FeatureID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
intYearBegin |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
strFeature |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
dteTimeStamp |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
dteLastUpdate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdFeature |
0 |
PRIMARY |
1 |
FeatureID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdFeatureGenre | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
FeatureID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
GenreID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdFeatureGenre |
0 |
PRIMARY |
1 |
FeatureID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdFeatureGenre |
0 |
PRIMARY |
2 |
GenreID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdFeatureGenre |
1 |
FK_gcdFeatureGenre2 |
1 |
GenreID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdFeatureGenre |
gcdFeature |
`FeatureID` |
`FeatureID` |
|
FK_gcdFeatureGenre2 |
gcdGenre |
`GenreID` |
`GenreID` |
|
gcdGenre | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
GenreID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strGenre |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdGenre |
0 |
PRIMARY |
1 |
GenreID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssue | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
IssueID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
IssueReprintID |
int(11) |
NULL |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
FormatTypeID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
PublicationMonthID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
intCountPage |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intPrinting |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intHeight |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
intWidth |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
intPublicationDay |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
intPublicationYear |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
strIndiciaTitle |
varchar(255) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
strIndiciaVolume |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
strIndiciaNumber |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
strDisambiguation |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dteTimeStamp |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
dteLastUpdate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdIssue |
0 |
PRIMARY |
1 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssue |
1 |
FK_gcdIssue |
1 |
PublicationMonthID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssue |
1 |
FK_gcdIssue2 |
1 |
FormatTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssue |
1 |
FK_gcdIssue3 |
1 |
IssueReprintID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdIssue |
supPublicationMonth |
`PublicationMonthID` |
`PublicationMonthID` |
|
FK_gcdIssue2 |
supFormat |
`FormatTypeID` |
`FormatID` |
|
FK_gcdIssue3 |
gcdIssue |
`IssueReprintID` |
`IssueID` |
|
gcdIssueCoverType | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
IssueID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CoverTypeID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdIssueCoverType |
0 |
PRIMARY |
1 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssueCoverType |
0 |
PRIMARY |
2 |
CoverTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssueCoverType |
1 |
FK_gcdIssueCoverType2 |
1 |
CoverTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdIssueCoverType |
gcdIssue |
`IssueID` |
`IssueID` |
|
FK_gcdIssueCoverType2 |
supCoverType |
`CoverTypeID` |
`CoverTypeID` |
|
gcdIssuePrice | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
IssueID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
CurrencyID |
varchar(4) |
latin1_swedish_ci |
|
PRI |
|
|
select,insert,update,references |
|
numPrice |
float |
NULL |
|
|
0 |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdIssuePrice |
0 |
PRIMARY |
1 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssuePrice |
0 |
PRIMARY |
2 |
CurrencyID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssuePrice |
1 |
FK_gcdIssuePrice2 |
1 |
CurrencyID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdIssuePrice |
gcdIssue |
`IssueID` |
`IssueID` |
|
FK_gcdIssuePrice2 |
supCurrency |
`CurrencyID` |
`CurrencyID` |
|
gcdIssuePublisher | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
IssueID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
PublisherID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
PublisherTypeID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdIssuePublisher |
0 |
PRIMARY |
1 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssuePublisher |
0 |
PRIMARY |
2 |
PublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssuePublisher |
0 |
PRIMARY |
3 |
PublisherTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssuePublisher |
1 |
FK_gcdIssuePublisher2 |
1 |
PublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssuePublisher |
1 |
FK_gcdIssuePublisher3 |
1 |
PublisherTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdIssuePublisher |
gcdIssue |
`IssueID` |
`IssueID` |
|
FK_gcdIssuePublisher2 |
gcdPublisher |
`PublisherID` |
`PublisherID` |
|
FK_gcdIssuePublisher3 |
supPublisherType |
`PublisherTypeID` |
`PublisherTypeID` |
|
gcdIssueStandardNumber | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
IssueStandardNumberID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
IssueID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
StandardNumberTypeID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
strStandardNumber |
varchar(16) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdIssueStandardNumber |
0 |
PRIMARY |
1 |
IssueStandardNumberID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssueStandardNumber |
1 |
FK_gcdIssueStandardNumber |
1 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdIssueStandardNumber |
1 |
FK_gcdIssueStandardNumber2 |
1 |
StandardNumberTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdIssueStandardNumber |
gcdIssue |
`IssueID` |
`IssueID` |
|
FK_gcdIssueStandardNumber2 |
supStandardNumberType |
`StandardNumberTypeID` |
`StandardNumberTypeID` |
|
gcdPublisher | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PublisherID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
CountryID |
varchar(6) |
latin1_swedish_ci |
|
MUL |
|
|
select,insert,update,references |
|
PublisherTypeID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
intCountComics |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intCountImprint |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intCountSeries |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intYearBegin |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intYearEnd |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
strNamePublisher |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
strDisambiguation |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dteTimeStamp |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
dteLastUpdate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdPublisher |
0 |
PRIMARY |
1 |
PublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdPublisher |
1 |
FK_gcdPublisher_PublisherType |
1 |
PublisherTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdPublisher |
1 |
FK_gcdPublisher_Country |
1 |
CountryID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdPublisher_Country |
supCountry |
`CountryID` |
`CountryID` |
|
FK_gcdPublisher_PublisherType |
supPublisherType |
`PublisherTypeID` |
`PublisherTypeID` |
|
gcdPublisherRelationship | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PublisherID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
RelatedPublisherID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
PublisherRelationshipID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
txtNote |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdPublisherRelationship |
0 |
PRIMARY |
1 |
PublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdPublisherRelationship |
0 |
PRIMARY |
2 |
RelatedPublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdPublisherRelationship |
0 |
PRIMARY |
3 |
PublisherRelationshipID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdPublisherRelationship |
1 |
FK_gcdPublisherRelationship_RelatedPublisher |
1 |
RelatedPublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdPublisherRelationship |
1 |
FK_gcdPublisherRelationship_PublisherRelationship |
1 |
PublisherRelationshipID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdPublisherRelationship_Publisher |
gcdPublisher |
`PublisherID` |
`PublisherID` |
|
FK_gcdPublisherRelationship_PublisherRelationship |
supPublisherRelationship |
`PublisherRelationshipID` |
`PublisherRelationshipID` |
|
FK_gcdPublisherRelationship_RelatedPublisher |
gcdPublisher |
`RelatedPublisherID` |
`PublisherID` |
|
gcdSeries | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SeriesID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
IssueBeginID |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
IssueEndID |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LanguageID |
varchar(6) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
intYearBegin |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intYearEnd |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
intCountComics |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
strNameSeries |
varchar(255) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dteTimeStamp |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
dteLastUpdate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdSeries |
0 |
PRIMARY |
1 |
SeriesID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeries |
1 |
FK_gcdSeries |
1 |
LanguageID |
A |
0 |
(NULL) |
(NULL) |
YES |
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdSeries |
supLanguage |
`LanguageID` |
`LanguageID` |
ON DELETE NO ACTION ON UPDATE NO ACTIO |
gcdSeriesIssue | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SeriesID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
IssueID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
intSortOrder |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
intVolume |
int(11) |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
strIssue |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdSeriesIssue |
0 |
PRIMARY |
1 |
SeriesID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesIssue |
0 |
PRIMARY |
2 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesIssue |
1 |
FK_gcdSeriesIssue2 |
1 |
IssueID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdSeriesIssue |
gcdSeries |
`SeriesID` |
`SeriesID` |
|
FK_gcdSeriesIssue2 |
gcdIssue |
`IssueID` |
`IssueID` |
|
gcdSeriesPublisher | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SeriesID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
PublisherID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdSeriesPublisher |
0 |
PRIMARY |
1 |
SeriesID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesPublisher |
0 |
PRIMARY |
2 |
PublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesPublisher |
1 |
FK_gcdSeriesPublisher |
1 |
PublisherID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdSeriesPublisher |
gcdPublisher |
`PublisherID` |
`PublisherID` |
|
FK_gcdSeriesPublisher2 |
gcdSeries |
`SeriesID` |
`SeriesID` |
|
gcdSeriesStandardNumber | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SeriesStandardNumberID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
SeriesID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
StandardNumberTypeID |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
strStandardNumber |
varchar(25) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdSeriesStandardNumber |
0 |
PRIMARY |
1 |
SeriesStandardNumberID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesStandardNumber |
1 |
FK_gcdSeriesStandardNumber |
1 |
SeriesID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesStandardNumber |
1 |
FK_gcdSeriesStandardNumber2 |
1 |
StandardNumberTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdSeriesStandardNumber |
gcdSeries |
`SeriesID` |
`SeriesID` |
|
FK_gcdSeriesStandardNumber2 |
supStandardNumberType |
`StandardNumberTypeID` |
`StandardNumberTypeID` |
|
gcdSeriesToSeries | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SeriesID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
SeriesToID |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
txtNotes |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gcdSeriesToSeries |
0 |
PRIMARY |
1 |
SeriesID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesToSeries |
0 |
PRIMARY |
2 |
SeriesToID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
gcdSeriesToSeries |
1 |
FK_gcdSeriesToSeries2 |
1 |
SeriesToID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Foreign Key Relationships |
FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_gcdSeriesToSeries |
gcdSeries |
`SeriesID` |
`SeriesID` |
|
FK_gcdSeriesToSeries2 |
gcdSeries |
`SeriesToID` |
`SeriesID` |
|
supCharacterAppearance | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CharacterAppearanceID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strCharacterAppearance |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supCharacterAppearance |
0 |
PRIMARY |
1 |
CharacterAppearanceID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supColorType | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ColorTypeID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strColorType |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supColorType |
0 |
PRIMARY |
1 |
ColorTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supContentType | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ContentTypeID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strContentType |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supContentType |
0 |
PRIMARY |
1 |
ContentTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supCountry | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CountryID |
varchar(6) |
latin1_swedish_ci |
|
PRI |
|
|
select,insert,update,references |
|
strCountry |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supCountry |
0 |
PRIMARY |
1 |
CountryID |
A |
247 |
(NULL) |
(NULL) |
|
BTREE |
|
supCoverType | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CoverTypeID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strCoverType |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supCoverType |
0 |
PRIMARY |
1 |
CoverTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supCreatorRelationship | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CreatorRelationshipID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strCreatorRelationship |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supCreatorRelationship |
0 |
PRIMARY |
1 |
CreatorRelationshipID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supCreatorRole | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CreatorRoleID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
intSort |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
strCreatorRole |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supCreatorRole |
0 |
PRIMARY |
1 |
CreatorRoleID |
A |
16 |
(NULL) |
(NULL) |
|
BTREE |
|
supCreatorRoleFlag | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CreatorRoleFlagID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strCreatorRoleFlag |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supCreatorRoleFlag |
0 |
PRIMARY |
1 |
CreatorRoleFlagID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supCurrency | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
CurrencyID |
varchar(4) |
latin1_swedish_ci |
|
PRI |
|
|
select,insert,update,references |
|
strCurrency |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supCurrency |
0 |
PRIMARY |
1 |
CurrencyID |
A |
4 |
(NULL) |
(NULL) |
|
BTREE |
|
supFormat | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
FormatID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strFormat |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supFormat |
0 |
PRIMARY |
1 |
FormatID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supLanguage | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
LanguageID |
varchar(4) |
latin1_swedish_ci |
|
PRI |
|
|
select,insert,update,references |
|
strLanguage |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supLanguage |
0 |
PRIMARY |
1 |
LanguageID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supNamePrefix | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
NamePrefixID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strNamePrefix |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supNamePrefix |
0 |
PRIMARY |
1 |
NamePrefixID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supNameSuffix | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
NameSuffixID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strNameSuffix |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supNameSuffix |
0 |
PRIMARY |
1 |
NameSuffixID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supPaperStock | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PaperStockID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strPaperStock |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supPaperStock |
0 |
PRIMARY |
1 |
PaperStockID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supPublicationMonth | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PublicationMonthID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strPublicationMonth |
varchar(20) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supPublicationMonth |
0 |
PRIMARY |
1 |
PublicationMonthID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supPublisherRelationship | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PublisherRelationshipID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strPublisherRelationship |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supPublisherRelationship |
0 |
PRIMARY |
1 |
PublisherRelationshipID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supPublisherType | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PublisherTypeID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strPublisherType |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescritpion |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supPublisherType |
0 |
PRIMARY |
1 |
PublisherTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
supStandardNumberType | |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
StandardNumberTypeID |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
strStandardNumberType |
varchar(50) |
latin1_swedish_ci |
|
|
|
|
select,insert,update,references |
|
txtDescription |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
supStandardNumberType |
0 |
PRIMARY |
1 |
StandardNumberTypeID |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|