project
Tables (4)
cart (Untitled4)
- cart_id (card id) — BIGINT — Primary key — NOT NULL
- user_id (user id) — BIGINT — Foreign key → user.user_id — NOT NULL
- product_id (product id) — BIGINT — Foreign key → product.product_id — NOT NULL
cart_item (Untitled3)
- cart_item_id (cart item id) — BIGINT — Primary key — NOT NULL
- cart_id (card id) — BIGINT — Foreign key → cart.cart_id — NOT NULL
- user_id (user id) — BIGINT — Foreign key → cart.user_id — NOT NULL
- product_id (product id) — BIGINT — Foreign key → cart.product_id — NOT NULL
- cart_date (카트 담은 최종날짜) — DATETIME
- cart_stock (카트 담은 수량) — BIGINT
product (Untitled2)
- product_id (product id) — BIGINT — Primary key — NOT NULL
- product_name (제품 이름) — varchar
- product_price (제품 가격) — BIGINT
- product_info (제품 정보) — varchar
- product_stock (제품 남은 수량) — BIGINT
user (Untitled)
- user_id (user id) — BIGINT — Primary key — NOT NULL
- ID (사용자 ID) — varchar
- password (사용자 비밀번호) — varchar
- email (사용자 이메일) — carchar
- enrolled_date (가입 날짜) — DATETIME