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 (영수증 상세 내역)
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