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