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