travel tracker
Tables (8)
BUDGET (예산)
- idx (Key3) — Primary key — NOT NULL
- name (Field) — NOT NULL
- total_amount (총 금액) — NOT NULL
- total_expense (총 사용 금액)
- pay_type (결제 종류) — NOT NULL — (공통, 현금, 카드)
- travel_idx (Key) — Foreign key → TRAVEL.idx — NOT NULL
- country_idx (Key2) — Foreign key → CURRENCY.idx — NOT NULL
CATEGORY (Untitled4)
- idx (Key) — Primary key — NOT NULL
- name (Field) — NOT NULL
- icon (Field2) — NOT NULL
- color (Field3) — NOT NULL
- travel_idx (Key2) — Foreign key → TRAVEL.idx — NOT NULL
CURRENCY (Untitled3)
- idx (Key) — Primary key — NOT NULL
- country_name (Field) — NOT NULL
- symbol (Field2) — NOT NULL — ex.₩
- code (Field4) — NOT NULL — ex. KRW
- flag_image (Field3) — NOT NULL
EXPENSE (지출)
- idx (Key) — Primary key — NOT NULL
- item (Field) — NOT NULL
- amount (Field3) — NOT NULL
- pay_type (결제 종류) — NOT NULL — 현금/카드
- type (지출 분류) — NOT NULL — 공동/개인/공금
- memo (Field2)
- image (Field4)
- created_time (Field5) — NOT NULL
- is_prepared (Y/N) — NOT NULL
- category_idx (Key2) — Foreign key → CATEGORY.idx — NOT NULL
- budget_idx (Key3) — Foreign key → BUDGET.idx — NOT NULL
- member_idx (Key32) — Foreign key → Member.idx — NOT NULL
INCOME (수입)
- idx (Key) — Primary key — NOT NULL
- item (Field3) — NOT NULL
- amount (Field) — NOT NULL
- created_time (Field2) — NOT NULL
- budget_idx (Key3) — Foreign key → BUDGET.idx — NOT NULL
- member_idx (Key32) — Foreign key → Member.idx — NOT NULL
Member (Untitled2)
- idx (Key3) — Primary key — NOT NULL
- travel_idx (Key2) — Foreign key → TRAVEL.idx — NOT NULL
- user_idx (Key4) — Foreign key → USER.idx — NOT NULL
TRAVEL (Untitled)
- idx (Key) — Primary key — NOT NULL
- title (Field3) — NOT NULL
- description (Field4)
- start_date (Field) — NOT NULL
- end_date (Field2) — NOT NULL
- cover_image (Field5)
- deducation_prepared (준비 금액 예산에서 차감 여부) — NOT NULL — Y/N (default:N)
USER (user)
- idx — Primary key — NOT NULL
- id
- name (Field) — NOT NULL
- email (Field2) — NOT NULL
- password (Field3)
- join_type (Field4) — NOT NULL
- status (활동 상태(탈퇴 여부)) — NOT NULL
- profile_image (Field6)
- default_currency (Field7)