test
Tables (9)
Address
- address_id — BIGINT(20) — Primary key — NOT NULL
- address — VARCHAR(255) — NOT NULL
- create_date — TIMESTAMP — NOT NULL
- modify_date — TIMESTAMP — NOT NULL
- member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
Carts
- cart_id — BIGINT(20) — Primary key — NOT NULL
- quantity — INT(11) — NOT NULL
- created_date — TIMESTAMP — NOT NULL
- modified_date — TIMESTAMP — NOT NULL
- item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL
- member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
- brand_id — BIGINT(20) — Foreign key → brand.brand_id — NOT NULL
Dibs
- dib_id — BIGINT(20) — Primary key — NOT NULL
- create_date — TIMESTAMP — NOT NULL
- modify_date — TIMESTAMP — NOT NULL
- member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
- item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL
Members
- member_id — BIGINT(20) — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- grade — VARCHAR(100) — NOT NULL
- role — VARCHAR(100) — NOT NULL
- current_address — VARCHAR(100)
- create_date — TIMESTAMP — NOT NULL
- modify_date — TIMESTAMP — NOT NULL
Orders
- order_id — BIGINT(20) — Primary key — NOT NULL
- payment_method — VARCHAR(255) — NOT NULL
- total_price — INT(15) — NOT NULL
- delivery_request — VARCHAR(255)
- create_date — TIMESTAMP — NOT NULL
- modify_date — TIMESTAMP — NOT NULL
- status — VARCHAR(255) — NOT NULL
- brand_id — BIGINT(20) — Foreign key → brand.brand_id — NOT NULL
- member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
Qna
- qna_id — BIGINT(20) — Primary key — NOT NULL
- category — VARCHAR(20) — NOT NULL
- status — VARCHAR(255) — NOT NULL
- item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL
- member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
Reviews
- review_id — BIGINT(20) — Primary key — NOT NULL
- rating — INT(1) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- create_date — TIMESTAMP — NOT NULL
- modify_date — TIMESTAMP — NOT NULL
- item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL
- member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
brand
- brand_id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- brand_picture_url — TEXT
- created_date — TIMESTAMP — NOT NULL
- modified_date — TIMESTAMP — NOT NULL
items
- item_id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- item_picture_url — TEXT
- content — VARCHAR(255) — NOT NULL
- rating — DECIMAL(3,1) — NOT NULL
- review_count — INT(11) — NOT NULL
- created_date — TIMESTAMP — NOT NULL
- modified_date — TIMESTAMP — NOT NULL
- quantity — INT(20) — NOT NULL
- brand_id — BIGINT(20) — Foreign key → brand.brand_id — NOT NULL