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