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