test2_stock4lio
Tables (28)
authority
- Key — not null — Primary key — NOT NULL
- planKey — not null — Foreign key → plan.serviceKey — NOT NULL
category (Untitled2)
- Key — not null — Primary key — NOT NULL
- parent_id (Key2) — null — Foreign key → category.Key — NOT NULL
category_l
- Key — not null — Primary key — NOT NULL
- stockKey — not null — Foreign key → stock.Key — NOT NULL
category_m
- Key — not null — Primary key — NOT NULL
- stockKey — not null — Foreign key → category_l.stockKey — NOT NULL
- catLKey — not null — Foreign key → category_l.Key — NOT NULL
category_s
- Key — null — Primary key — NOT NULL
- catMKey — not null — Foreign key → category_m.Key — NOT NULL
- stockKey — not null — Foreign key → category_m.stockKey — NOT NULL
- catLKey — not null — Foreign key → category_m.catLKey — NOT NULL
confirm_email
- Key — not null — Primary key — NOT NULL
- userKey — not null — Foreign key → user.Key — NOT NULL
- email — not null
- is_main — not null
contact info
- groupKey — not null — Foreign key → group.Key — NOT NULL
- folioKey — not null — Foreign key → folio.Key — NOT NULL
- type — not null — Foreign key → group.type
- email — null
- website — null
- phone — null
- fax — null
content
- Key — Primary key — NOT NULL
- fileKey — not null — Foreign key → file.Key — NOT NULL
- title — not null
- description — null
- preview — not null
- downloaded_count — not null
- catSKey — null — Foreign key → category_s.Key — NOT NULL
- catMKey — not null — Foreign key → category_s.catMKey — NOT NULL
- stockKey — not null — Foreign key → category_s.stockKey — NOT NULL
- catLKey — not null — Foreign key → category_s.catLKey — NOT NULL
- folioKey — not null — Foreign key → folio.Key — NOT NULL
- serviceKey — not null — Foreign key → folio.serviceKey — NOT NULL
- userKey — not null — Foreign key → folio.userKey — NOT NULL
- view_count — not null
corporate
- Key — not null — Primary key — NOT NULL
- type — not null — Foreign key → group.type
- passcode — not null
- folioKey — not null — Foreign key → folio.Key — NOT NULL
crew
- Key — Primary key — NOT NULL
- type — not null — Foreign key → group.type
- folioKey — not null — Foreign key → folio.Key — NOT NULL
file
- Key — not null — Primary key — NOT NULL
- licenseKey — not null — Foreign key → license.Key — NOT NULL
- name — not null
- attach_type — not null
- byte_size — not null
- height — null
- width — null
- quality — not null
folio
- Key — not null — Primary key — NOT NULL
- serviceKey — not null — Foreign key → service.Key — NOT NULL
- userKey — not null — Foreign key → user.Key — NOT NULL
- nickname — not null
- picture — not null
- picture_type — not null
- career — not null
- resume — null
- active — not null
group
- Key — not null — Primary key — NOT NULL
- type — not null — Primary key
- name — not null
- logo (logova) — not null
- group_info — null
- start_date — not null
- enabled — not null
- Field
license
- Key — not null — Primary key — NOT NULL
- folioKey — not null — Foreign key → folio.Key — NOT NULL
- guide — not null
plan
- Key — not null — Primary key — NOT NULL
- serviceKey — not null — Foreign key → service.Key — NOT NULL
service
- Key — not null — Primary key — NOT NULL
stock
- Key — not null — Primary key — NOT NULL
- serviceKey — not null — Foreign key → service.Key — NOT NULL
tag
- Key — Primary key — NOT NULL
- date_created — not null
- description — null
- name — not null
- tagged_count — not null
user
- Key — not null — Primary key — NOT NULL
- username — not null
- password — not null
- enabled — not null
- date_created — not null
- withdraw — not null
- date_withdraw — not null
- create_ip — not null
- last_update_ip — null
- last_update — not null
user_role
- userKey — not null — Foreign key → user.Key — NOT NULL
- authorityKey — not null — Foreign key → authority.Key — NOT NULL
- planKey — not null — Foreign key → authority.planKey — NOT NULL