KORAVEL

Tables (4)

plan

  • plan_id (plan id) — bigint — Primary key — NOT NULL
  • user_id (user id) — bigint
  • plan_name (plan name) — varchar
  • theme (plan theme) — varchar
  • start_date (plan start date) — datetime
  • end_date (plan end date) — datetime
  • scope (plan scope) — tinyint
  • number_of_members (number of members in plan) — int
  • number_of_scraps (number of scraps in plan) — int
  • created_at (plan created at) — timestamp
  • modified_at (plan modified at) — timestamp

plan_budget (plan budget)

  • budget_id (plan budget id) — bigint — Primary key — NOT NULL
  • schedule_id (plan schedule id) — bigint
  • budget_category (plan budget category) — varchar
  • cost (plan budget cost) — int
  • created_at (plan budget created_at) — timestamp
  • modified_at (plan budget modified at) — timestamp

plan_schedule (plan schedule)

  • schedule_id (schedule id) — bigint — Primary key — NOT NULL
  • plan_id (plan id) — bigint
  • schedule_date (schedule date) — datetime
  • place_category (place category) — varchar
  • place_name (place name) — varchar
  • region — varchar
  • place_memo (place memo) — varchar
  • arrival_time (arrival time) — time
  • x (x)

user_entity (user entity)

  • id (user id) — bigint — Primary key — NOT NULL
  • username — varchar
  • password (user password) — varchar
  • email (user email) — varchar
  • nickname (user nickname) — varchar
  • role (user role) — varchar
  • login_type (user login type) — varchar
  • created_at (user created at) — timestamp
  • updated_at (user updated at) — timestamp