발주 서비스
테이블 (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