tlan
Tables (14)
accommodation
- place_id — BIGINT — NOT NULL
- phone_number — VARCHAR(255)
attraction
- place_id — BIGINT — NOT NULL
- open_now — BIT(1)
- opening_hours_text — VARCHAR(512)
chat
- id — BIGINT — NOT NULL
- content — VARCHAR(255)
- created_at — DATETIME(6)
- travel_id — BIGINT
- user_id — BIGINT
country_info
- country_code — VARCHAR(255) — NOT NULL
- country_name — VARCHAR(255)
- currency_code — VARCHAR(255)
currency_rate
- currency_code — VARCHAR(255) — NOT NULL
- rate — DOUBLE
email_verification_token
- id — BIGINT — NOT NULL
- expire_date — DATETIME(6)
- token — VARCHAR(255)
- user_id — BIGINT
flight
- airline — VARCHAR(255)
- arrival_time — VARCHAR(255)
- departure_time — VARCHAR(255)
- pricekrw — INT(11)
- return_arrival_time — VARCHAR(255)
- return_departure_time — VARCHAR(255)
notifications
- id — BIGINT — NOT NULL
- content — VARCHAR(255)
- created_at — DATETIME(6)
- related_url — VARCHAR(255)
- user_id — BIGINT
place
- id — BIGINT — NOT NULL
- address — VARCHAR(255)
- google_place_id — VARCHAR(255)
- latitude — DOUBLE
- longitude — DOUBLE
- name — VARCHAR(255)
- type — VARCHAR(255)
- updated_at — DATETIME(6)
restaurant
- place_id — BIGINT — NOT NULL
- open_now — BIT(1)
- opening_hours_text — VARCHAR(512)
- phone_number — VARCHAR(255)
travel
- id — BIGINT — NOT NULL
- country_code — VARCHAR(255)
- end_date — DATE
- start_date — DATE
- title — VARCHAR(255)
- flight_id — BIGINT
- user_id — BIGINT
- departure — VARCHAR(255)
- traveler_count — INT(11)
travel_permission
- id — BIGINT — NOT NULL
- role — VARCHAR(255)
- travel_id — BIGINT
- user_id — BIGINT
travel_plans
- id — BIGINT — NOT NULL
- day_number — INT(11)
- memo — VARCHAR(255)
- sequence — INT(11)
- place_id — BIGINT
- travel_id — BIGINT
users
- id — BIGINT — NOT NULL
- email — VARCHAR(255) — NOT NULL
- email_verified — BIT(1)
- nickname — VARCHAR(255)
- password — VARCHAR(255)