shop

Tables (12)

BaseEntity (Untitled)

  • createdAt (Field) — Datetime
  • updatedAt (Field3) — Datetime
  • deletedYn (Field2) — boolean

Cart (장바구니)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL
  • price_id (Key3) — int — Foreign key → Price.id — NOT NULL
  • id (Key32) — int — Foreign key → Price.user_id — NOT NULL
  • count (Field2) — int

Category (카테고리)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — String

Comment (상품 문의 답변)

  • id (Key) — int — Primary key — NOT NULL
  • board_id (Key22) — int — Foreign key → Inquiry.price_id — NOT NULL
  • Field
  • Field2

Inquiry (상품 문의)

  • id (Key) — int — Primary key — NOT NULL
  • price_id (Key2) — int — Foreign key → Price.id — NOT NULL
  • user_id (Key3) — int — Foreign key → User.id — NOT NULL
  • title (Field) — String
  • content (Field2) — String

Orders (주문)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL
  • price (Field) — int
  • order_date (Field2) — Datetime
  • status (Field3) — String
  • name (Field4) — String
  • address (Field5) — String
  • address_detail (Field6) — String
  • phone (Field7) — String
  • message (Field8) — String

Orders_detail (주문 상세)

  • Key — Primary key — NOT NULL
  • orders_id (Key2) — int — Foreign key → Orders.id — NOT NULL
  • id (Key22) — int — Foreign key → Orders.user_id — NOT NULL
  • price_id (Field2) — int
  • image (Field5) — String
  • name (Field) — String
  • count (Field4) — int
  • cost (Field3) — int

Price (상품)

  • id (Key) — int — Primary key — NOT NULL
  • category_id (Key2) — int — Foreign key → Category.id — NOT NULL
  • user_id (Key3) — int — Foreign key → User.id — NOT NULL
  • image (Field7) — String
  • name (Field) — String
  • cost (Field2) — int
  • company (Field3) — String
  • country (Field4) — String
  • material (Field5) — String
  • size (Field6) — int
  • soldYn (Field8) — boolean
  • count (Field9) — int

Price_detail (상품 상세정보)

  • id (Key) — int — Primary key — NOT NULL
  • price_id (Key2) — int — Foreign key → Price.id — NOT NULL
  • text (Field) — String
  • image (Field2) — String
  • video (Field3) — String

User (회원)

  • id (Key) — int — Primary key — NOT NULL
  • username (Field4) — String
  • email (Field3) — String
  • loginId (Field) — String
  • password (Field2) — String
  • status (Field5) — String
  • roles (Field6) — String

User_address (회원 배송지)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL
  • name (Field) — String
  • address (Field2) — String
  • zipcode (Field3) — String
  • address_detail (Field4) — String
  • phone (Field5) — String
  • defaultYn (Field6) — boolean

media (이미지, 영상 경로)

  • id (Key) — int — Primary key — NOT NULL
  • price_detail_id (Key22) — int — Foreign key → Price_detail.price_id — NOT NULL
  • type (Field) — String
  • path (Field2) — String