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