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)