MINIMART
Tables (19)
cart
- user_id — INTEGER — Foreign key → user.id — NOT NULL
cartitem
- user_id — INTEGER — Foreign key → cart.user_id — NOT NULL
- item_id — INTEGER — Foreign key → item.id — NOT NULL
chat
- id — INTEGER — Primary key — NOT NULL
- buyer_id — INTEGER — NOT NULL
- seller_id — INTEGER — NOT NULL
- is_blocked — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
chat_message
- id — INTEGER — Primary key — NOT NULL
- content — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- chat_id — INTEGER — NOT NULL
- writer — ENUM('SELLER','BUYER') — NOT NULL
- Field — VARCHAR(255)
follow
- buyer_id — INTEGER — Foreign key → user.id — NOT NULL
- seller_id — INTEGER — Foreign key → seller.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
hashtag
- id — INTEGER — Primary key — NOT NULL
- content — VARCHAR(100) — NOT NULL
item
- id — INTEGER — Primary key — NOT NULL
- seller_id — INTEGER — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — INTEGER — NOT NULL
- stock_number — INTEGER — NOT NULL
- description — TEXT
- status — ENUM('FOR_SALE','SOLD_OUT','DISCONTINUED') — NOT NULL
- is_sale — TINYINT(1) — NOT NULL
- sale — FLOAT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
item_hashtag
- id — INTEGER — Foreign key → item.id — NOT NULL
- id2 — INTEGER — Foreign key → hashtag.id — NOT NULL
item_img
- id — INTEGER — Primary key — NOT NULL
- item_id — INTEGER — NOT NULL
- img_url — INTEGER — NOT NULL
- rep_img_yn — TINYINT(1) — NOT NULL
item_option
- id — INTEGER — Primary key — NOT NULL
- item_id — INTEGER — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — INTEGER — NOT NULL
- req_item_yn — TINYINT(1) — NOT NULL
item_review
- item_id — INTEGER — Foreign key → item.id — NOT NULL
- buyer_id — INTEGER — Foreign key → user.id — NOT NULL
- content — TEXT — NOT NULL
- img — VARCHAR(255)
- rating — FLOAT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
order
- id — INTEGER — Primary key — NOT NULL
- buyer_id — INTEGER
- created_at — TIMESTAMP — NOT NULL
- status — ENUM('PAID','SHIPPING','DELIVERED') — NOT NULL
- password — VARCHAR(255)
- is_user — TINYINT(1) — NOT NULL
orderitem
- order_id — INTEGER — Foreign key → order.id — NOT NULL
- item_id — INTEGER — Foreign key → item.id — NOT NULL
- item_option_id — INTEGER — NOT NULL
- count — INTEGER — NOT NULL
qna_board
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — NOT NULL
- title — VARCHAR(100) — NOT NULL
- q_content — TEXT — NOT NULL
- is_public — TINYINT(1) — NOT NULL
- admin_id — INTEGER
- a_content — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
qna_board_img
- id — INTEGER — Primary key — NOT NULL
- qna_borad_id — INTEGER — NOT NULL
- img_url — VARCHAR(255) — NOT NULL
seller
- id — INTEGER — Foreign key → user.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- introduce — TEXT
- phone_number — VARCHAR(13) — NOT NULL
- banner_img — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
seller_hashtag
- id — INTEGER — Foreign key → hashtag.id — NOT NULL
- id2 — INTEGER — Foreign key → seller.id — NOT NULL
seller_review
- buyer_id — INTEGER — Foreign key → user.id — NOT NULL
- seller_id — INTEGER — Foreign key → seller.id — NOT NULL
- content — TEXT — NOT NULL
- img — VARCHAR(255)
- rating — FLOAT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
user
- id — INTEGER — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(100)
- password — VARCHAR(255)
- adress — VARCHAR(255)
- phone_number — VARCHAR(13)
- profile_img — VARCHAR(255)
- provider — ENUM('local','google','kakao')
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- role — ENUM('BUYER','SELLER','ADMIN') — NOT NULL
- provider_id — VARCHAR(100) — NOT NULL
- age — INTEGER