Mannatime
Tables (7)
Participant (방 참가자)
- ParticipantId (participant_id) — Long — Primary key — NOT NULL
- RoomTitle (room_title) — varchar
- ParticipantName (participant_name) — varchar
- Password (password) — varchar
- EntryDateTime (entry_date_time) — datetime
- RoomId (room_id) — Long — Foreign key → Room.RoomId — NOT NULL
- UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL
Room (방)
- RoomId (room_id) — Long — Primary key — NOT NULL
- Title (title) — varchar
- StartTime (start_time) — time
- EndTime (end_time) — time
- ParticipantLimit (participant_limit) — int
- CreatedDateTime (created_date_time) — datetime
- LastUsed (last_used) — datetime
- ExpireDate (expire_date) — datetime
- Status (status) — varchar
RoomDate (방의 설정 기간)
- Serial (serial) — Long — Primary key — NOT NULL
- RoomId (room_id) — Long — Foreign key → Room.RoomId — NOT NULL
- ScheduledDate (scheduled_date) — date
Schedule (가능하다고 입력한 시간)
- Serial (serial) — Primary key — NOT NULL
- ParticipantId (participant_id) — Long — Foreign key → Participant.ParticipantId — NOT NULL
- AvailableDate (available_date) — date
- StartTime (start_time) — time
- EndTime (end_time) — time
User (회원가입된 유저)
- UserId (user_id) — Long — Primary key — NOT NULL
- Username (username) — varchar
- Password (password) — varchar
- Email (email) — varchar
- LastLogin (last_login) — datetime
- SignInDateTime (sign_in_date_time) — datetime
- LastModified (Field2)
- Field4
User_Activity (유저 로그)
- Key — Primary key — NOT NULL
- UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL
- Activity (activity) — varchar
User_Room (유저 - 방 연관관계 매핑 테이블 (x))
- UserRoomId (user_room_id) — Long — Primary key — NOT NULL
- UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL
- RoomId (room_id2) — Long — Foreign key → Room.RoomId — NOT NULL
- RoomTitle (room_title) — varchar