111

Tables (7)

Copy Of Untitled (CopyOfUntitled)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

categories

  • category_id — UUID
  • name — VARCHAR(100) — NOT NULL — 카테고리명
  • description — TEXT — 설명
  • created_at — TIMESTAMP — 생성일시

order_items

  • order_item_id — UUID
  • order_id — UUID — Foreign key → orders.order_id — NOT NULL — 주문
  • product_id — UUID — Foreign key → products.product_id — NOT NULL — 상품
  • quantity — INTEGER — NOT NULL — 수량
  • price — amount_domain — NOT NULL — 단가

orders

  • order_id — UUID
  • user_id — UUID — Foreign key → users.user_id — NOT NULL — 사용자
  • total_amount — amount_domain — NOT NULL — 총
  • status — status_domain — NOT NULL — 주문
  • ordered_at — TIMESTAMP — 주문일시

products

  • product_id — UUID
  • category_id — UUID — Foreign key → categories.category_id — NOT NULL — 카테고리
  • name — VARCHAR(200) — NOT NULL — 상품명
  • price — amount_domain — NOT NULL — 가격
  • stock — INTEGER — NOT NULL — 재고
  • status — status_domain — 상태
  • created_at — TIMESTAMP — 생성일시

users

  • user_id — UUID
  • email — email_domain — NOT NULL — 이메일
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • status — status_domain — NOT NULL — 상태
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — 수정일시

ㅇㅇㅇ (Untitled)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4