lunch
Tables (7)
bookmark_spot
- id — bigint
- address — varchar(255)
- menu — varchar(255)
- operation_hour — varchar(255)
- rate — varchar(255)
- registered_at — datetime
- restaurant — varchar(255)
- user_id — bigint
- updated_at — datetime
favorite_user
- id — bigint
- nick_name — varchar(255)
- registered_at — datetime
- favorite_user_id — bigint
- user_id — bigint
- updated_at — datetime
must_eat_place
- id — bigint
- address — varchar(255)
- city — varchar(255)
- menu — varchar(255)
- operation_hour — varchar(255)
- rate — varchar(255)
- restaurant — varchar(255)
- registered_at — datetime
- updated_at — datetime
plan
- id — bigint
- registered_at — datetime
- plan_menu — varchar(255)
- plan_restaurant — varchar(255)
- plan_status — varchar(255)
- plan_time — datetime
- accepter_id — bigint
- requester_id — bigint
- request_message — varchar(255)
- updated_at — datetime
plan_history
- id — bigint
- registered_at — datetime
- plan_id — bigint
- requester_id — bigint
- accepter_id — bigint
- updated_at — datetime
user
- id — bigint
- company — varchar(255)
- latitude — double
- longitude — double
- registered_at — datetime
- user_email — varchar(255)
- user_name — varchar(10)
- user_password — varchar(255)
- user_phone_number — varchar(12)
- user_rate — double
- updated_at — datetime
- user_role — varchar(255)
- user_status — varchar(255)
- image_url — varchar(255)
- name_card_url — varchar(255)
- profile_url — varchar(255)
- created_at — datetime
- email — varchar(255)
- login_type — varchar(255)
- nick_name — varchar(255)
- password — varchar(255)
- phone — varchar(255)
- status — varchar(255)
user_review
- id — bigint
- rate — double
- registered_at — datetime
- review_content — varchar(255)
- updated_at — datetime
- plan_id — bigint
- reviewer_id — bigint
- targeted_id — bigint