Session_BE

Tables (12)

ChatMember

  • chatroom_id (chatroom_id2) — INT — Foreign key → ChatRoom.chatroom_id
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • joined_at — DATETIME
  • status — ENUM('active', 'left')

ChatMessage

  • message_id — INT — Primary key
  • chatroom_id (chatroom_id2) — INT — Foreign key → ChatRoom.chatroom_id
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • message_text — TEXT — NOT NULL
  • created_at — DATETIME
  • messgae_image (message_image) — VARCHAR(255)

ChatRoom

  • chatroom_id — INT — Primary key
  • chatroom_name — VARCHAR(100) — NOT NULL
  • chatroom_url — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE
  • travel_style — VARCHAR(50)
  • date_confirmed — BOOLEAN
  • created_at — DATETIME
  • destination — VARCHAR(50)

Friend

  • User_id — INT — Primary key — NOT NULL
  • friend_id — INT — Foreign key → User.user_id
  • status — ENUM("Requested"."Friend")

Issue

  • issue_id — INT — Primary key — NOT NULL
  • chatroom_id — INT — Foreign key → ChatRoom.chatroom_id
  • title — VARCHAR(20)
  • create_type — ENUM
  • participant — INT
  • created_at — DATETIME
  • deadline — DATETIME
  • status — ENUM
  • deadline_alarm — BOOLEAN

PlaceData

  • place_id — INT
  • name — VARCHAR(200) — NOT NULL
  • category — VARCHAR(100)
  • address — VARCHAR(255)
  • rating_count — INT
  • avg_rating — DECIMAL(3,2)
  • map_url — VARCHAR(255)
  • img_url — VARCHAR(255)
  • created_at — DATETIME

Poll

  • issue_id — INT — Foreign key → Issue.issue_id — NOT NULL
  • poll_id — INT
  • multi_choice — BOOLEAN
  • anonymity — BOOLEAN
  • choice1 — VARCHAR(20)
  • choice2 — VARCHAR(20)
  • choice3 — VARCHAR(20)
  • choice4 — VARCHAR(20)
  • choice5 — VARCHAR(20)
  • cnt1 — INT
  • cnt2 — INT
  • cnt3 — INT
  • cnt4 — INT
  • cnt5 — INT

Profile

  • profile_id — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • nickname — VARCHAR(50)
  • Bdate — DATETIME
  • email — VARCHAR(100)
  • profile_img — VARCHAR(255)

TripPreference

  • pref_id — INT — Primary key
  • profile_id — INT — Foreign key → Profile.profile_id
  • travel_style — VARCHAR(50)
  • created_at — DATETIME
  • Pace — VARCHAR(20)
  • Rhythm — VARCHAR(20)
  • Diet — VARCHAR(20)
  • Allergy — VARCHAR(20)

TripSummary

  • summary_id — INT
  • chatroom_id — INT — NOT NULL
  • summary_title — VARCHAR(100)
  • total_budget — DECIMAL(15,2)
  • status — ENUM('planning', 'ongoing', 'done')
  • created_at — DATETIME

TripTask

  • task_id — INT
  • summary_id — INT — NOT NULL
  • task_name — VARCHAR(100) — NOT NULL
  • assigned_to — INT
  • due_date — DATE
  • status — ENUM('pending', 'in_progress', 'done')
  • note — TEXT
  • created_at — DATETIME

User

  • user_id — INT — Primary key
  • user_pw — VARCHAR(255) — NOT NULL
  • created_at — DATETIME