likelion14th
Tables (7)
category (Untitled7)
- category_id (카테고리ID) — long — Primary key — NOT NULL
- name (카테고리명) — VARCHAR
comment (Untitled6)
- comment_id (댓글아이디) — VARCHAR — Primary key — NOT NULL
- content (댓글내용) — Text
- date (댓글날짜) — DateTime
- Field
- user_id — long — Foreign key → user.user_id — NOT NULL
- review_id (리뷰아이디) — VARCHAR — Foreign key → review.review_id — NOT NULL
item (Untitled2)
- item_id (상품id) — INT — Primary key — NOT NULL
- name (상품이름) — VARCHAR
- price (상품가격) — Long
- photo_img (상품이미지) — VARCHAR
- stock (상품재고) — INT
- description (상품설명) — VARCHAR
- category_id (카테고리명) — VARCHAR — Foreign key → category.category_id — NOT NULL
order (Untitled4)
- order_id (주문번호) — long — Primary key — NOT NULL
- date (주문날짜) — DATETIME
- status (주문상태) — VARCHAR
- total_amount (총결제금액) — long
- user_id — long — Foreign key → user.user_id — NOT NULL
order_item (Untitled5)
- item_order_id (상품주문ID) — INT — Primary key — NOT NULL
- item_count (주문개수) — INT
- order_id (주문번호) — long — Foreign key → order.order_id — NOT NULL
- item_id (상품id) — INT — Foreign key → item.item_id — NOT NULL
- order_price (주문당시 단가) — long
review (Untitled3)
- review_id (리뷰아이디) — long — Primary key — NOT NULL
- score (별점) — Double
- content (리뷰내용) — TEXT
- date (리뷰날짜) — DATETIME
- user_id — long — Foreign key → user.user_id — NOT NULL
- item_id (상품id) — INT — Foreign key → item.item_id — NOT NULL
user (Untitled)
- user_id — long — Primary key — NOT NULL
- name (이름) — VARCHAR
- email (이메일) — VARCHAR
- password (비밀번호) — VARCHAR
- photo_img (프로필사진) — VARCHAR
- sns_id (소셜로그인아이디) — VARCHAR