Columns
| 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 |
|
|
||||||||
| help | varchar | 2000 | √ | null |
|
|
||||||||
| wstoreemail | varchar | 60 | √ | null |
|
|
||||||||
| wstoreuser | varchar | 60 | √ | null |
|
|
||||||||
| wstoreuserpw | varchar | 20 | √ | null |
|
|
||||||||
| webinfo | varchar | 2000 | √ | null |
|
|
||||||||
| webparam1 | varchar | 2000 | √ | null |
|
|
||||||||
| webparam2 | varchar | 2000 | √ | null |
|
|
||||||||
| webparam3 | varchar | 2000 | √ | null |
|
|
||||||||
| webparam4 | varchar | 2000 | √ | null |
|
|
||||||||
| webparam5 | varchar | 2000 | √ | null |
|
|
||||||||
| webparam6 | varchar | 2000 | √ | null |
|
|
||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| bpchar | 1 | 'Y'::bpchar |
|
|
||||||||||
| emailheader | varchar | 2000 | √ | null |
|
|
||||||||
| varchar | 2000 | √ | null |
|
|
|||||||||
| salesrep_id | numeric | 10 | null |
|
|
|||||||||
| m_warehouse_id | numeric | 10 | null |
|
|
|||||||||
| m_pricelist_id | numeric | 10 | null |
|
|
|||||||||
| webcontext | varchar | 20 | null |
|
|
|||||||||
| weborderemail | varchar | 60 | √ | null |
|
|
||||||||
| c_paymentterm_id | numeric | 10 | √ | null |
|
|
||||||||
| isdefault | bpchar | 1 | 'N'::bpchar |
|
|
|||||||||
| url | varchar | 120 | 'http://localhost'::character varying |
|
|
|||||||||
| stylesheet | varchar | 60 | √ | null |
|
|
||||||||
| w_store_uu | varchar | 36 | √ | NULL::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| w_store_pkey | Primary key | Asc | w_store_id |
| w_store_uu_idx | Must be unique | Asc | w_store_uu |
| w_store_webcontext | Must be unique | Asc | webcontext |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| w_store_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenurequests_check | ((ismenurequests = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenuregistrations_check | ((ismenuregistrations = 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))) |
| w_store_ismenuinterests_check | ((ismenuinterests = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenucontact_check | ((ismenucontact = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenurfqs_check | ((ismenurfqs = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenushipments_check | (((ismenushipments = 'Y'::bpchar) OR (ismenushipments = 'N'::bpchar))) |
| w_store_ismenuinvoices_check | ((ismenuinvoices = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| w_store_ismenuassets_check | ((ismenuassets = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |