receipe

Tables (8)

Category (적요)

  • category_id (Key) — UUID — Primary key — NOT NULL
  • category_name (Field) — varchar
  • category_pormpt (Field2) — text

Meeting (모임)

  • meeting_id (Key) — UUID — Primary key — NOT NULL
  • meeting_name (Field) — varchar
  • role (Field2) — enum

Meeting_Category_Budget (팀별 적요별 예산)

  • budget_id (Key) — UUID — Primary key — NOT NULL
  • meeting_id (Key2) — UUID — Foreign key → Meeting.meeting_id — NOT NULL
  • category_id (Key3) — UUID — Foreign key → Category.category_id — NOT NULL
  • total_budjet (Field) — DECIMAL
  • used_budget (Field2) — DECIMAL

Receipt_Management (영수증 관리)

  • receipt_management_id (Key) — UUID — Primary key — NOT NULL
  • receipt_id (영수증 ID) — UUID — Foreign key → Reciept.receipt_id — NOT NULL
  • transfer_status (Field5) — boolean
  • settlement_status (Field6) — boolean
  • status (Field7) — ENUM

Reciept (영수증)

  • receipt_id (영수증 ID) — UUID — Primary key — NOT NULL
  • meeting_id (Key) — UUID — Foreign key → Meeting.meeting_id — NOT NULL
  • receipt_date (결제 일자) — varchar
  • total_amount (결제 금액) — enum
  • image_url (이미지 저장 url)
  • description (영수증 상세 내역)

Role (권한)

    User (사용자)

    • user_id (Key) — PK — Primary key — NOT NULL
    • user_name (Field) — varchar
    • email (Field2) — varchar
    • account_number (Field3) — varhar

    UserMeeting (참자가 테이블)

    • use_metting_id (PK) — Primary key — NOT NULL
    • user_id (FK) — PK — Foreign key → User.user_id — NOT NULL
    • meeting_id (Key3) — UUID — Foreign key → Meeting.meeting_id — NOT NULL