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