ㅇ
Tables (12)
board
- board_id — bigint — Primary key — NOT NULL
- title — varchar(50) — NOT NULL
- nickname — varchar(255) — NOT NULL
- content — TEXT — NOT NULL
- hashtag — varchar(100)
- comment_count — int — NOT NULL
- view_count — int
- like_count — int
- view_contain — varbinary(50)
- like_contain — varbinary(50)
- created_at — TIMESTAMP
- category_id — varchar(20)
- user_id — bigint — Foreign key → user.user_id — NOT NULL
cart
- cart_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
cart_item
- cart_item_id — bigint — Primary key — NOT NULL
- quantity — int
- price — decimal
- cart_id — bigint — Foreign key → cart.cart_id — NOT NULL
- product_id — bigint — Foreign key → product.product_id — NOT NULL
categories
- category_id — bigint — Primary key — NOT NULL
- category_name — varchar(50) — NOT NULL
comment
- comment_id — bigint — Primary key — NOT NULL
- nickname — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- like_count — int — NOT NULL
- like_contain — varbinary(50)
- reply_contain — varbinary(50)
- created_at — TIMESTAMP
- board_id — bigint — Foreign key → board.board_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
delivery
- delivery_id — bigint — Primary key — NOT NULL
- purchase_id — bigint — Foreign key → purchase.purchase_id — NOT NULL
- delivery_state — varchar(10) — NOT NULL
- receiver_name — varchar(20) — NOT NULL
- receiver_phone — varchar(20) — NOT NULL
- receiver_addr — varchar(100) — NOT NULL
- delivery_msg — varchar(200) — NOT NULL
product
- product_id — bigint — Primary key — NOT NULL
- product_name — varchar(255) — NOT NULL
- content — TEXT
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- image_url — varchar(500)
- average_rating — DECIMAL(10, 2)
- subcategory_id — bigint — Foreign key → subcategories.subcategory_id — NOT NULL
- category_id — bigint — Foreign key → categories.category_id — NOT NULL
purchase
- purchase_id — bigint — Primary key — NOT NULL
- created_at — datetime
- purchase_state — varchar(255)
- user_id — bigint — Foreign key → user.user_id — NOT NULL
purchase_products
- purchase_product_id — bigint — Primary key — NOT NULL
- purchase_id — bigint — Foreign key → purchase.purchase_id — NOT NULL
- product_id — bigint — Foreign key → product.product_id — NOT NULL
- price — decimal(10, 2)
- quantity — int
- option — varchar(100)
- review_state — varchar(5)
reviews
- review_id — bigint — Primary key — NOT NULL
- rating — DECIMAL(2, 1) — NOT NULL
- comment — TEXT
- created_at — TIMESTAMP
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- product_id — bigint — Foreign key → product.product_id — NOT NULL
subcategories
- subcategory_id — bigint — Primary key — NOT NULL
- subcategory_name — varchar(50) — NOT NULL
- description — TEXT
- category_id (category_id2) — bigint — Foreign key → categories.category_id — NOT NULL
user
- user_id — bigint — Primary key — NOT NULL
- userid — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(60) — NOT NULL
- role — varchar(255) — NOT NULL
- address — varchar(255)
- question — varchar(255)
- answer — varchar(255)
- created_at — DATETIME