clientsheme

1000 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
attributemetafield.field_id FK_27349990443707B0R
categorymetafield.field_id FK_CCC871B443707B0R
countrymetafield.field_id FK_887C52DD443707B0R
currencymetafield.field_id FK_8BDE5573443707B0R
customergroupmetafield.field_id FK_79B37F32443707B0R
customermetafield.field_id FK_9773404F443707B0R
documentmetafield.field_id FK_3477F239443707B0R
languagemetafield.field_id FK_D7145B5A443707B0R
manufacturermetafield.field_id FK_3E6E93F6443707B0R
offeritemmetafield.field_id FK_6AD9A6B9443707B0R
offermetafield.field_id FK_C2CBB302443707B0R
ordermetafield.field_id FK_5A4EE1D1443707B0R
paymentmetafield.field_id FK_FB704108443707B0R
productmetafield.field_id FK_700669F7443707B0R
productoptionmetafield.field_id FK_14D15167443707B0R
shippingmetafield.field_id FK_27594DCF443707B0R
statemetafield.field_id FK_844565C7443707B0R
taxmetafield.field_id FK_5B22A2DE443707B0R
usermetafield.field_id FK_5B3BE760443707B0R
table_id VARCHAR 36 null
tablesheme.id FK_A9EC8861ECFF285CR
client_id VARCHAR 36 null
client.id FK_A9EC886119EB6921R
field VARCHAR 255 null
displayName VARCHAR 255 null
fieldType VARCHAR 32 null
translatable BIT 1 null
grouping VARCHAR 36 null
sort INT 10 null
readOnly BIT 1 null
selectboxValues LONGTEXT 2147483647 null
fieldset VARCHAR 36 null
inheritable BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
field_idx Performance Asc field
IDX_A9EC886119EB6921 Performance Asc client_id
IDX_A9EC8861ECFF285C Performance Asc table_id

Relationships