marketCurly
Tables (6)
ITEM (item)
- ID (id) — BIGINT(20) — Primary key — NOT NULL
- Key (id2) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
- ITEM_NAME (item_name) — VARCHAR(40)
- CATEGORY (category) — VARCHAR(40)
- IS_NEW (is_new) — BOOLEAN
- PRICE (price) — BIGINT(20)
- DESCRIPTION (descriptioin) — VARCHAR(255)
- DETAIL (detail) — TEXT
- STOCK (stock) — BIGINT(20)
REVIEW (review)
- ID (id) — BIGINT(20) — Primary key — NOT NULL
- ID (id2) — BIGINT(20) — Foreign key → ITEM.ID — NOT NULL
- ID (id3) — BiIGINT(20) — Foreign key → USER.ID — NOT NULL
- Key (id22) — BIGINT(20) — Foreign key → ITEM.Key — NOT NULL
- Key (id23) — BIGINT(20) — Foreign key → USER.Key — NOT NULL
- REGISTER_TIME (register_time) — DATETIME
- DETAIL (content) — TEXT
- Field (edit_time) — DATETIME
- Field (title) — VARCHAR(255)
REVIEW_IMG
- Key (id) — BIGINT(20) — Primary key — NOT NULL
- ID (id2) — BIGINT(20) — Foreign key → REVIEW.ID — NOT NULL
- ID (id22) — BIGINT(20) — Foreign key → REVIEW.ID — NOT NULL
- ID (id3) — BiIGINT(20) — Foreign key → REVIEW.ID — NOT NULL
- Key (id222) — BIGINT(20) — Foreign key → REVIEW.Key — NOT NULL
- Key (id23) — BIGINT(20) — Foreign key → REVIEW.Key — NOT NULL
- Field (img_url) — VARCHAR(255)
USER (user)
- ID (id) — BiIGINT(20) — Primary key — NOT NULL
- Key (id2) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
- LOGIN_ID (login_id) — VARCHAR(30)
- PASSWORD (password) — VARCHAR(40)
- NICKNAME (nickname) — VARCHAR(30)
- NAME (name) — VARCHAR(255)
- BIRTHDAY (birthday) — DATE
- IS_ADMIN (is_admin) — BOOLEAN
- REGISTER_TIME (register_time) — DATETIME
Untitled (qna)
- Key (id) — BIGINT(20) — Primary key — NOT NULL
- ID (id2) — BiIGINT(20) — Foreign key → USER.ID — NOT NULL
- ID (id3) — BIGINT(20) — Foreign key → ITEM.ID — NOT NULL
- Key (id22) — BIGINT(20) — Foreign key → ITEM.Key — NOT NULL
- Key (id23) — BIGINT(20) — Foreign key → USER.Key — NOT NULL
- Field (register_time) — DATETIME
- Field (edit_time) — DATETIME
- Field (title) — VARCHAR(255)
- Field (content) — TEXT
Untitled (shopping_bag)
- Key (id) — BIGINT(20) — Primary key — NOT NULL