fffffff
Tables (9)
authentications
- id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → users.id — NOT NULL
- kind — tinyint(3) — NOT NULL
- access_id — varchar(64)
- access_key — varchar(128)
- default — tinyint(3)
- status — tinyint(3)
- created_at — int(10)
- updated_at — int(10)
group_brands
- id — int(10) — Primary key — NOT NULL
- product_brand_id — int(10) — Foreign key → product_brands.id — NOT NULL
- product_group_id — int(10) — Foreign key → product_groups.id — NOT NULL
- created_at — int(10)
product_brands
- id — int(10) — Primary key — NOT NULL
- vendor_id — int(10) — NOT NULL
- name — varchar(64) — NOT NULL
- logo_path — varchar(255)
- status — tinyint(4)
- created_at — int(10)
- updated_at — int(10)
product_groups
- id — int(10) — Primary key — NOT NULL
- vendor_id — int(10) — NOT NULL
- name — varchar(64) — NOT NULL
- status — tinyint(4)
- created_at — int(10)
- updated_at — int(10)
products
- id — int(10) — Primary key — NOT NULL
- vendor_id — int(10) — Foreign key → vendors.id — NOT NULL
- product_group_id — int(10) — Foreign key → product_groups.id
- product_brand_id — int(10) — Foreign key → product_brands.id
- name — varchar(255) — 상품명
- snapshot_path — varchar(255) — 상품 이미지
- options — text — 옵션
- detail — varchar(255) — 한줄설명
- explanation — text — 상세설명
- price — int(10) — NOT NULL — 가격
- status — tinyint(3)
- created_at — int(10)
- updated_at — int(10)
- deleted_at — int(10)
role_users
- id — int(10) — Primary key — NOT NULL
- role_id — int(10) — Foreign key → roles.id — NOT NULL
- user_id — int(10) — Foreign key → users.id — NOT NULL
- created_at — int(10)
roles
- id — int(10) — Primary key — NOT NULL
- key — varchar(64) — NOT NULL
- name — varchar(64) — NOT NULL
- reference — varchar(64)
- reference_id — int(10)
- created_at — int(10)
- updated_at — int(10)
users
- id — int(10) — Primary key — NOT NULL
- name — varchar(64) — NOT NULL
- password — varchar(64)
- phone — varchar(64)
- status — tinyint(4)
- signed_at — int(10)
- created_at — int(10)
- updated_at — int(10)
- deleted_at — int(11)
vendors
- id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → users.id — NOT NULL
- name — varchar(255) — NOT NULL
- key — varchar(255) — NOT NULL
- logo_path — varchar(255)
- status — tinyint(3)
- created_at — int(10)
- updated_at — int(10)
- deleted_at — int(10)