Mocamp

Tables (5)

goal

  • goal_id — long — Primary key — NOT NULL
  • content — varchar(256)
  • is_completed — tinyint
  • joined_room_id — long — Foreign key → joined_room.joined_room_id — NOT NULL

image

  • image_id — long — Primary key — NOT NULL
  • type — enum("profile", "room")
  • path — vachar(128)

joined_room

  • joined_room_id — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id
  • room_id — long — Foreign key → room.room_id — NOT NULL
  • is_admin — tinyint
  • is_participating — tinyint
  • is_deleted — tinyint
  • is_secret — tinyint
  • resolution — varchar(64)
  • work_status — tinyint
  • mic_status — tinyint
  • cam_status — tinyint

room

  • room_id — long — Primary key — NOT NULL
  • room_name — varchar(64)
  • room_seq — varchar(64)
  • capacity — int
  • room_num — int
  • status — tinyint
  • started_at — datetime
  • ended_at — datetime
  • duration — time
  • notice — varchar(64) — NOT NULL
  • image_id — long — Foreign key → image.image_id — NOT NULL
  • is_deleted — tinyint
  • mic_availability — tinyint

user

  • user_id — long — Primary key
  • user_seq — varchar(64) — NOT NULL
  • username — varchar(64)
  • password — varchar(128)
  • email — varchar(64)
  • email_verified_yn — char(1)
  • created_at — datetime
  • modified_at — datetime
  • image_id — long — Foreign key → image.image_id — NOT NULL