DbModel
Tables (9)
Budget
- budget_id — INT — Primary key
- room_id — INT — Foreign key → Schedule.room_id — NOT NULL
- schedule_id — INT — Foreign key → Schedule.schedule_id
- item_name — VARCHAR(20) — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- description — VARCHAR(50)
ChatRoom
- room_id — INT — Primary key — NOT NULL
- room_name — VARCHAR(20) — NOT NULL
- created_at (created time) — TIMESTAMP
FriendList
- flist_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- friend_id — INT
InviteCode
- code_id — INT — Primary key — NOT NULL
- room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL
- code — VARCHAR(100) — NOT NULL
- expiration_date — DATE — NOT NULL
Message
- message_id — INT — Primary key — NOT NULL
- room_id (room_id2) — INT — Foreign key → ChatRoom.room_id — NOT NULL
- room_id — INT
- user_id — INT
- content — TEXT
- created_at — TIMESTAMP
Photo
- photo_id — INT — Primary key — NOT NULL
- room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL
- file_path — VARCHAR(255)
- uploaded_at (uploaded_time) — TIMESTAMP
RoomMember
- user_id — INT — Foreign key → User.user_id — NOT NULL
- room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL
Schedule
- schedule_id — INT — Primary key — NOT NULL
- room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- date — SMALLDATETIME — NOT NULL
- description — VARCHAR(50)
- place — VARCHAR(20)
User
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- name — VARCHAR(10) — NOT NULL
- profile_image — VARCHAR(255)
- friends — INT