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)