| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| w_store_id | numeric | 10 | null |
|
|
|||||||||
| ad_client_id | numeric | 10 | null |
|
|
|||||||||
| ad_org_id | numeric | 10 | null |
|
|
|||||||||
| isactive | bpchar | 1 | 'Y'::bpchar |
|
|
|||||||||
| created | timestamp | 29,6 | now() |
|
|
|||||||||
| createdby | numeric | 10 | null |
|
|
|||||||||
| updated | timestamp | 29,6 | now() |
|
|
|||||||||
| updatedby | numeric | 10 | null |
|
|
|||||||||
| name | varchar | 60 | null |
|
|
|||||||||
| description | varchar | 255 | √ | null |
|
|
| Constraint Name | Constraint |
|---|---|
| w_store_ismenuinterests_check | ((ismenuinterests = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenurfqs_check | ((ismenurfqs = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenuregistrations_check | ((ismenuregistrations = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenucontact_check | ((ismenucontact = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenuinvoices_check | ((ismenuinvoices = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenurequests_check | ((ismenurequests = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenuassets_check | ((ismenuassets = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenuorders_check | ((ismenuorders = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenupayments_check | (((ismenupayments = 'Y'::bpchar) OR (ismenupayments = 'N'::bpchar))) |