trip-plan
Tables (23)
Accommodation (tbl_accommodation)
- accommodation id (id) — BIGINT — Primary key — NOT NULL
- trip id — BIGINT — Foreign key → Trip.trip id — NOT NULL
- accommodation title (accommodation_title) — varchar — NOT NULL
- accommodation content (accommodation_content) — varchar
- accommodation address (address) — varchar
- accommodation address coordinates (coordinates) — POINT
- reservation date (reservation_check_in_date) — DATETIME
- Field (reservation_check_out_date) — DATETIME
- accommodation created date (created_date) — DATETIME — NOT NULL
- accommodation modified date (modified_date) — DATETIME — NOT NULL
- accommodation removed date (removed_date) — DATETIME
Accommodation File (tbl_accommodation_file)
- accommodation id (accommodation_id) — BIGINT — Foreign key → Accommodation.accommodation id — NOT NULL
- file id (file_id) — BIGINT — Foreign key → File.file id — NOT NULL
Attractions (tbl_ attractions)
- attractions id (id) — BIGINT — Primary key — NOT NULL
- trip id (trip_id) — BIGINT — Foreign key → Trip.trip id — NOT NULL
- attractions title (attractions_title) — varchar — NOT NULL
- attractions content (attractions_content) — varchar
- attractions address (address) — varchar
- attractions address coordinates (coordinates) — POINT
- expected date of visit (visit_date) — DATETIME
- attractions ticket needed (ticket_needed) — boolean
- has attractions ticket (has_ticket) — boolean
- attractions ticket price (ticket_price) — BIGINT
- attractions created date (created_date) — DATETIME — NOT NULL
- attractions modified date (modified_date) — DATETIME — NOT NULL
- attractions removed date (removed_date) — DATETIME
Attractions File (tbl_attractions_file)
- attractions id (attractions_id) — BIGINT — Foreign key → Attractions.attractions id — NOT NULL
- file id (file_id) — BIGINT — Foreign key → File.file id — NOT NULL
Budget (tbl_budget)
- budget id (id) — BIGINT — Primary key — NOT NULL
- trip id (trip_id) — BIGINT — Foreign key → Trip.trip id — NOT NULL
- user id (user_id) — BIGINT — Foreign key → Trip.user id — NOT NULL
- initial budget (initail_budget) — BIGINT
- current budget (current_budget) — BIGINT
- public or private (access_type) — varchar
- budget created date (created_date) — DATETIME
- budget modifited date (modified_date) — DATETIME
- budget removed date (removed_date) — DATETIME
Budget History (tbl_budget_history)
- budget history id (id) — BIGINT — Primary key — NOT NULL
- budget id (budget_id) — BIGINT — Foreign key → Budget.budget id — NOT NULL
- user id (user_id) — BIGINT — Foreign key → Budget.user id — NOT NULL
- transaction date (transaction_date) — DATETIME
- transaction description (description) — varchar
- transaction amount (amount) — BIGINT
- budget balance (balance) — BIGINT
- budget history created date (created_date) — DATETIME
- budget history modified date (modified_date) — DATETIME
- budget history removed date (removed_date) — DATETIME
Chat Message (tbl_chat_message)
- chat message id (id) — BIGINT — Primary key — NOT NULL
- user id (user_id) — BIGINT — Foreign key → User.user id — NOT NULL
- chat room id (chat_room_id) — BIGINT — Foreign key → Chat Room.chat room id — NOT NULL
- chat message (caht_message) — varchar
- chat message created date (created_date) — DATETIME
Chat Room (tbl_chat_room)
- chat room id (id) — BIGINT — Primary key — NOT NULL
- last chat message (last_chat_message) — varchar
- chat room created date (created_date) — DATETIME
- chat room removed date (removed_date) — DATETIME
Check List (tbl_check_list)
- check list id (id) — BIGINT — Primary key — NOT NULL
- trip id (trip_id) — BIGINT — Foreign key → Trip.trip id — NOT NULL
- check list content (check_list_content) — varchar
- yes or no (is_checked) — boolean
- check list created date (created_date) — DATETIME
- check list modified date (modified_date) — DATETIME
- check list removed date (removed_date) — DATETIME
Community (tbl_community)
- community id (id) — BIGINT — Primary key — NOT NULL
- trip id (trip_id) — BIGINT — Foreign key → Trip.trip id — NOT NULL
- user id (user_id) — BIGINT — Foreign key → Trip.user id — NOT NULL
- community content (community_content) — varchar
- community tag (community_tag) — JSON
- community created date (created_date) — DATETIME — NOT NULL
- community modified date (modified_date) — DATETIME — NOT NULL
- community removed date (removed_date) — DATETIME
Community File (tbl_community_file)
- community id (id) — BIGINT — Foreign key → Community.community id — NOT NULL
- file id (file_id) — BIGINT — Foreign key → File.file id — NOT NULL
Community Reply (tbl_community_reply)
- community reply id (id) — BIGINT — Primary key — NOT NULL
- community id (community_id) — BIGINT — Foreign key → Community.community id — NOT NULL
- user id (user_id) — BIGINT — Foreign key → Community.user id — NOT NULL
- community reply content (reply_content) — varchar
- community reply depth (parrent_id) — BIGINT
- community reply created date (created_date) — DATETIME
- community reply modified date (modified_date) — DATETIME
- community reply removed date (removed_date) — DATETIME
File (tbl_file)
- file id (file_id) — BIGINT — Primary key — NOT NULL
- file name (file_name) — varchar — NOT NULL
- file path (file_path) — varchar — NOT NULL
- file size (file_size) — INTEGER — NOT NULL
- file created date (created_date) — DATETIME — NOT NULL
- file modified date (modified_date) — DATETIME — NOT NULL
- file removed date (removed_date) — DATETIME
Restaurant (tbl_ restaurant)
- restaurant id (id) — BIGINT — Primary key — NOT NULL
- trip id (trip_id) — BIGINT — Foreign key → Trip.trip id — NOT NULL
- restaurant title (restaurant_title) — varchar — NOT NULL
- restaurant content (restaurant_content) — varchar
- restaurant address (address) — varchar
- restaurant address coordinates (coordinates) — POINT
- expected date of visit (visit_date) — DATETIME
- restaurant start time, restaurant end time, restaurant break time (business_time) — JSON
- restaurant created date (created_date) — DATETIME — NOT NULL
- restaurant modified date (modified_date) — DATETIME — NOT NULL
- restaurant removed date (removed_date) — DATETIME
Restaurant File (tbl_restaurant_file)
- restaurant id (restaurant_id) — BIGINT — Foreign key → Restaurant.restaurant id — NOT NULL
- file id (file_id) — BIGINT — Foreign key → File.file id — NOT NULL
Team (tbl_team)
- team id (id) — BIGINT — Primary key — NOT NULL
- user id (user_id) — BIGINT — Foreign key → User.user id — NOT NULL
- team name (team_name)
- team created date (created_date) — DATETIME — NOT NULL
- team modified date (modified_date) — DATETIME — NOT NULL
- team removed date (removed_date) — DATETIME
Team Members (tbl_team_members)
- team member id (id) — BIGINT — Primary key — NOT NULL
- team id (team_id) — BIGINT — Foreign key → Team.team id — NOT NULL
- team role (team_role) — varchar
- team member created id (created_id) — DATETIME
- team member modified id (modified_id) — DATETIME
- team member removed id (removed_id) — DATETIME
Transportation (tbl_transportation)
- transportation id (id) — BIGINT — Primary key — NOT NULL
- trip id (trip_id) — BIGINT — Foreign key → Trip.trip id — NOT NULL
- user id (user_id) — BIGINT — Foreign key → Trip.user id — NOT NULL
- transportation title (transportation_title) — varchar — NOT NULL
- transportation content (transportation_content) — varchar
- transportation address (address) — varchar
- transportation coordinates address (coordinates) — POINT
- public or private (access_type) — varchar
- reservation date (reservation_date) — DATETIME
- transportation created date (created_date) — DATETIME — NOT NULL
- transportation modified date (modified_date) — DATETIME — NOT NULL
- transportation removed date (removed_date) — DATETIME
Transportation File (tbl_transportation_file)
- transportation id (transportation_id) — BIGINT — Foreign key → Transportation.transportation id — NOT NULL
- file id (file_id) — BIGINT — Foreign key → File.file id — NOT NULL
Trip (tbl_trip)
- trip id (id) — BIGINT — Primary key — NOT NULL
- user id (user_id) — BIGINT — Foreign key → User.user id — NOT NULL
- team id (team_id) — BIGINT — Foreign key → Team.team id — NOT NULL
- trip title (trip_title) — varchar
- trip content (trip_content) — varchar
- trip start date (trip_start_date) — DATETIME
- trip end date (trip_end_date) — DATETIME
- yes or no (is_public) — boolean
- trip created date (created_date) — DATETIME
- trip modified date (modified_date) — DATETIME
- trip removed date (removed_date) — DATETIME
User (tbl_user)
- user id (id) — BIGINT — Primary key — NOT NULL
- user email (email) — varchar — NOT NULL
- user name (name) — varchar — NOT NULL
- user login type (login_type) — varchar
- user sns profile url (sns_profile_url) — varchar
- user information retention period (expiration_period) — DATETIME
- user created date (created_date) — DATETIME — NOT NULL
- user modified date (modified_date) — DATETIME — NOT NULL
- user removed date (removed_date) — DATETIME
chat member (tbl_chat_member)
- user id (id) — BIGINT — Foreign key → User.user id — NOT NULL
- chat room id (chat_room_id) — BIGINT — Foreign key → Chat Room.chat room id — NOT NULL
memo (tbl_memo)
- memo id (id) — BIGINT — Primary key — NOT NULL
- trip id (trip_id) — BIGINT — Foreign key → Trip.trip id — NOT NULL
- user id (user_id) — BIGINT — Foreign key → Trip.user id — NOT NULL
- memo content (memo_content) — varchar
- public or private (access_type) — varchar
- memo created date (created_date) — DATETIME
- memo modified date (modified_date) — DATETIME
- memo removed dater (removed_date) — DATETIME