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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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

 

Back

 
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`

Back

 
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

 

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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`

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back

 
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

 

Back