dd
Tables (12)
board
- board_id — BIG — Primary key — NOT NULL
- user_id — BIG — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- hashtag — varchar(10) — NOT NULL
- viewcount — int — NOT NULL
- commentcount — int — NOT NULL
- likecount — int — NOT NULL
- viewcontain — varbinary(500) — NOT NULL
- likecontain — varbinary(500) — NOT NULL
- create_at — DATE — NOT NULL
cart
- cart_id — BIG — Primary key — NOT NULL
- user_id — BIG — Foreign key → user.user_id — NOT NULL
cart_item
- cart_item_id — BIG — Primary key — NOT NULL
- cart_id — BIG — Foreign key → cart.cart_id — NOT NULL
- user_id — BIG — Foreign key → cart.user_id — NOT NULL
- product_id — BIG — NOT NULL
category
- category_id — BIG — Primary key — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
comment
- comment_id — BIG — Primary key — NOT NULL
- board_id — BIG — NOT NULL
- user_id — BIG — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- content — varchar(200) — NOT NULL
- likecount — int — NOT NULL
- likecontain — varbinary(500) — NOT NULL
- create_at — DATE — NOT NULL
- replycontain — varbinary(500) — NOT NULL
delivery
- delivery_id — BIG — Primary key — NOT NULL
- purchase_product_id — VARCHAR(255) — NOT NULL
product
- product_id — BIG — Primary key — NOT NULL
- product_name — TEXT — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- create_at — DATE — NOT NULL
- option — VARCHAR(255)
- content — TEXT — NOT NULL
- description — TEXT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- average_rating — DECIMAL(10,2)
- category_id — BIG — NOT NULL
- subcategory_id — BIG — NOT NULL
purchase
- purchase_id — BIG — Primary key — NOT NULL
- totalprice — DECIMAL — NOT NULL
- discount — VARCHAR
- create_at — DATE — NOT NULL
- cancel_at — DATE — NOT NULL
- cart_id — BIG
- user_id — BIG
- user_id2 — BIG — NOT NULL
purchase_product
- purchase_product_Id — BIG — Primary key — NOT NULL
- purchase_id — BIG — Primary key — NOT NULL
- product_id — BIG — Foreign key → product.product_id — NOT NULL
- option — VARCHAR(100)
- quantity — INT — NOT NULL
- price — INT — NOT NULL
- review_state — VARCHAR(10) — NOT NULL
- cart_item_id2 — BIG — NOT NULL
- cart_id — BIG — NOT NULL
- user_id — BIG — NOT NULL
reviews
- review_id — BIG_INT — Primary key — NOT NULL
- rating — DECIMAL(2,1) — NOT NULL
- comment — TEXT — NOT NULL
- create_at — TIMESTAMP — NOT NULL
- product_id — BIG — NOT NULL
- user_id — BIG — NOT NULL
subcategory
- subcategory_id — BIG — Primary key — NOT NULL
- category_id — BIG — NOT NULL
- subcategory_name — VARCHAR(50) — NOT NULL
- description — TEXT — NOT NULL
user
- user_id — BIG — Primary key — NOT NULL
- userid — VARCHAR(30) — NOT NULL — UNIQUE
- password — VARCHAR(60) — NOT NULL
- email — VARCHAR(100) — NOT NULL — UNIQUE
- nickname — VARCHAR(20) — NOT NULL — UNIQUE
- question — VARCHAR(50)
- answer — VARCHAR(20)
- accountType — VARCHAR(255) — NOT NULL
- create_at — DATE — NOT NULL