Shinhan

Tables (5)

budget

  • primary_key (budget_id) — INT — Primary key — NOT NULL
  • foreign_key (user_id) — INT — Foreign key → user.primary_key — NOT NULL
  • int_field (daily_budget) — INT
  • int_field (expected_cost) — INT
  • int_field (remains) — INT
  • bool_field (over_budget) — BOOL
  • char_field (sticker_sort) — VARCHAR(100)

calendar

  • primary_key (calendar_id) — INT — Primary key — NOT NULL
  • foreign_key (user_id) — INT — Foreign key → user.primary_key — NOT NULL
  • date_feild (date) — DATE

schedule

  • primary_key (schedule_id) — int — Primary key — NOT NULL
  • foreign_key (calendar_id) — INT — Foreign key → calendar.primary_key — NOT NULL
  • foreign_key (user_id) — INT — Foreign key → calendar.foreign_key — NOT NULL
  • char_field (personal_schedule) — VARCHAR(300)
  • int_field (cost_limit) — INT
  • char_field (category) — VARCHAR(100)
  • int_field (expected_cost) — INT
  • int_field (daily_budget) — INT

user

  • primary_key (user_id) — INT — Primary key — NOT NULL
  • char_field (name) — VARCHAR(50)
  • int_field (age) — INT
  • char_field (gender) — VARCHAR(50)
  • int_field (interval) — INT

withdraw

  • primary_key (withdraw_id) — INT — Primary key — NOT NULL
  • foreign_key (schedule_id) — int — Foreign key → schedule.primary_key — NOT NULL
  • foreign_key (calendar_id) — INT — Foreign key → schedule.foreign_key — NOT NULL
  • foreign_key (user_id) — INT — Foreign key → user.primary_key — NOT NULL
  • int_field (amount) — INT
  • date_time_field (time) — DATETIME
  • char_field (category) — VARCHAR(100)