ZEYO
Tables (4)
item
- id — BIGINT(20) — Primary key — NOT NULL
- shopmall_id — BIGINT(20) — Foreign key → shopmall.id — NOT NULL
- sub_category_id — BIGINT(20) — Foreign key → sub_category.id
- code — VARCHAR(255) — NOT NULL
- image — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- price — INT(11) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- hit — BIGINT(20) — NOT NULL
member
- id — BIGINT(20) — Primary key — NOT NULL
- member_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
shopmall
- id — BIGINT(20) — Primary key — NOT NULL
- member_id — BIGINT(20) — Foreign key → member.id
- name — VARCHAR(255) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- use_yn — CHAR(1)
sub_category
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- parent_id — BIGINT(20)
- use_yn — CHAR(1) — NOT NULL