발주 서비스

테이블 (14)

Categories (Untitled8)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • name (Field) — String
  • sort_order (Field2) — Integer
  • created_at (Field3) — LocalDate

Comments (Untitled11)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • id (PK2) — UUID — 외래 키 → Posts.id — NOT NULL
  • user_id (PK3) — UUID — 외래 키 → Users.user_id — NOT NULL
  • content (Field) — Text
  • created_at (Field2) — LocalDate

Favorites (Untitled6)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • product_id (PK2) — UUID — 외래 키 → Products.id — NOT NULL
  • store_id (PK3) — UUID — 외래 키 → Stores.store_id — NOT NULL
  • created_at (Field) — LocalDate

Inventories (Untitled5)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • product_id (PK2) — UUID — 외래 키 → Products.id — NOT NULL
  • store_id (PK3) — UUID — 외래 키 → Stores.store_id — NOT NULL
  • current_qty (Field) — Integer
  • min_qty (Field2) — Integer
  • updated_at (Field3) — LocalDate

Notifications (Untitled12)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • user_id (PK2) — UUID — 외래 키 → Users.user_id — NOT NULL
  • title (Field) — String
  • message (Field2) — String
  • channel (Field3) — Enum
  • is_read (Field4) — Boolean
  • link_url (Field5) — String
  • sent_at (Field6) — LocalDate

Order_items (Untitled7)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • Field
  • order_id (PK3) — UUID — 외래 키 → Orders.id — NOT NULL
  • product_id (PK2) — UUID — 외래 키 → Products.id — NOT NULL
  • quantity (Field2) — Integer
  • unit_price (ㅇ) — Integer
  • subtotal (Field3) — integer

Orders (Untitled9)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • store_id (PK2) — UUID — 외래 키 → Stores.store_id — NOT NULL
  • order_number (Field) — String
  • status (Field2) — Enum
  • reject_reason (Field3) — String
  • total_amount (Field4) — Integer
  • payment_type (Field5) — Enum
  • requested_at (Field6) — LocalDate
  • approved_at (Field7) — LocalDate
  • delivered_at (Field8) — LocalDate

Payments (Untitled3)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • store_id (PK3) — UUID — 외래 키 → Stores.store_id — NOT NULL
  • order_id (PK2) — UUID — 외래 키 → Orders.id — NOT NULL
  • amount (Field) — Integer
  • method (Field2) — Enum
  • status (Field3) — Enum
  • pg_transaction_id (Field4) — String
  • paid_at (Field5) — LocalDate
  • Field6

Posts (Untitled10)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • user_id (PK2) — UUID — 외래 키 → Users.user_id — NOT NULL
  • board_type (Field) — Enum
  • title (Field2) — String
  • content (Field3) — Text
  • status (Field4) — Enum
  • view_count (Field5) — Integer
  • is_pinned (Field6) — Boolean
  • created_at (Field7) — LocalDate

Product_Requests (Untitled13)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • store_id (PK2) — UUID — 외래 키 → Stores.store_id — NOT NULL
  • product_name (Field) — String
  • description (Field2) — String
  • status (Field3) — Enum
  • created_at (Field4) — LocalDate

Products (Untitled4)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • Field
  • category_id (PK2) — UUID — 외래 키 → Categories.id — NOT NULL
  • name (Field2) — String
  • unit (Field3) — String
  • unit_price (Field4) — Integer
  • image_url (Field5) — String
  • min_order_qty (Field6) — Integer
  • is_active (Field7) — Boolean
  • created_at (Field8) — LocalDate

Settlements (월별 일괄 정산 단위)

  • id (PK) — UUID — 기본 키 — NOT NULL
  • store_id (PK2) — UUID — 외래 키 → Stores.store_id — NOT NULL
  • year (Field) — Integer
  • month (Field2) — Integer
  • total_amount (Field3) — Integer
  • paid_amount (Field4) — Integer
  • unpaid_amount (Field5) — Integer
  • status (Field6) — Enum
  • due_date (Field7) — LocalDate
  • pdf_url (Field8) — String
  • created_at (Field9) — LocalDate

Stores (Untitled)

  • store_id (PK) — UUID — 기본 키 — NOT NULL
  • user_id (PK2) — UUID — 외래 키 → Users.user_id — NOT NULL
  • store_name (Field) — String
  • address (Field2) — String
  • phone (Field3) — String
  • status (Field4) — Enum
  • created_at (Field5) — LocalDate

Users (Untitled2)

  • user_id (PK) — UUID — 기본 키 — NOT NULL
  • name (Field) — String
  • email (이메일) — String
  • password_hash (비밀번호) — String
  • phone (전화번호) — String
  • role (직급) — enum
  • invite_code (Field2) — String
  • is_approved (Field3) — Boolean
  • created_at (Field4) — LocalDate