be-miniproject
Tables (12)
board (게시글)
- id (게시판 id) — big int — Primary key — NOT NULL
- title (제목) — varchar(50)
- content (내용) — varchar(255)
- id (사용자_id) — big int — Foreign key → users.id — NOT NULL
- id (상품_id) — big int — Foreign key → products.id — NOT NULL
board_comment (게시글_댓글)
- id (Key) — big int — Primary key — NOT NULL
- content (내용) — text
- id (사용자_id) — big int — Foreign key → users.id — NOT NULL
- id (게시판 id) — big int — Foreign key → board.id — NOT NULL
- parent_id (부모댓글id) — big int
carts (장바구니)
- id (장바구니_id) — big int — Primary key — NOT NULL
- qty (수량) — int
- created_at (Field) — date
- updated_at (Field2) — date
- id (사용자_id) — big int — Foreign key → users.id — NOT NULL
- id (상품_id) — big int — Foreign key → products.id — NOT NULL
delivery (Untitled3)
- id (Key) — big int — Primary key — NOT NULL
- address (Field) — varchar(255)
- created_at (Field3) — date
- ordered_at (Field4) — date
- delivery_status (Field5) — varchar(20)
event_product (이벤트_상품)
- id (이벤트_상품_id) — big int — Primary key — NOT NULL
- id (상품_id2) — big int — Foreign key → products.id — NOT NULL
- id (이벤트_id) — big int — Foreign key → events.id — NOT NULL
events (이벤트)
- id (이벤트_id) — big int — Primary key — NOT NULL
- name (이벤트 이름) — varchar(100)
- created_at (생성일자) — date
- updated_at (수정일자) — date
- start_date (시작일자) — date
- end_date (종료일자) — date
like_product (찜한 상품)
- id (찜한상품_id) — big int — Primary key — NOT NULL
- user_id (사용자_id) — big int — Foreign key → users.id — NOT NULL
- product_id (상품_id2) — big int — Foreign key → products.id — NOT NULL
order_product (주문_상품)
- id (주문_상품_id) — big int — Primary key — NOT NULL
- price (주문 가격) — int
- qty (주문 수량) — int
- product_id (상품_id) — big int — Foreign key → products.id — NOT NULL
- order_id (주문_id) — big int — Foreign key → orders.id — NOT NULL
orders (주문)
- id (주문 id) — big int — Primary key — NOT NULL
- number (주문번호) — varchar(20)
- created_at (생성일자) — date
- updated_at (수정일자) — date
- id (사용자_id) — big int — Foreign key → users.id — NOT NULL
- order_status (주문 상태) — varchar(20)
product_comment (상품_댓글)
- id (Key) — big int — Primary key — NOT NULL
- content (Field) — text
- id (사용자_id) — big int — Foreign key → users.id — NOT NULL
- id (상품_id) — big int — Foreign key → products.id — NOT NULL
- parent_id (부모댓글id) — big int
products (상품)
- id (상품_id) — big int — Primary key — NOT NULL
- price (가격) — int
- discount (할인) — float
- rating (별점) — float
- thumbnail (이미지url) — varchar(255)
- description (설명)
- brand (브랜드)
- qty (수량)
- created_ad (생성일자) — date
- updated_at (수정일자) — date
users (사용자)
- id (사용자_id) — big int — Primary key — NOT NULL
- name (사용자_이름)
- email (이메일)
- password (비밀번호)
- address (주소)
- phone_number (전화번호)
- role (권한)
- created_at (생성일자) — date
- updated_at (수정일자) — date
- epay (이페이) — int
- simplePassword (간편결제번호) — char(6)