ERD_V1
Tables (9)
attendance_check
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- user_id — binary(16) — NOT NULL
- created_at — datetime — NOT NULL
friend
- cid — binary(16) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- user_id — binary(16) — NOT NULL
- friend_id — binary(16) — NOT NULL
- allow — bit — NOT NULL
- created_at — datetime — NOT NULL
record
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- start_time — datetime
- end_time — datetime
- total_study_time — bigint
- studying — bit — NOT NULL
- user_id — binary(16) — NOT NULL
room_chat
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- content — varchar(255) — NOT NULL
- study_room_id — varchar(36) — NOT NULL
- user_id — varchar(36) — NOT NULL
- created_at — datetime — NOT NULL
room_user
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- user_id — binary(16) — NOT NULL
- study_room_id — binary(16) — NOT NULL
study_category
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- name — varchar(255)
- description — varchar(255)
study_goal
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- goal_title — varchar(255)
- goal_detail — varchar(255)
- goal_time — bigint
- start_date — datetime
- end_date — datetime
- user_id — binary(16) — NOT NULL
study_room
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36)
- study_category_id — binary(16) — NOT NULL
- name — varchar(255) — NOT NULL
- maximum_number_of_people — integer — NOT NULL
- study_goal_time — bigint
- room_password — varchar(255)
- created_at — datetime — NOT NULL
- updated_at — datetime
- master_user_id — varchar(36) — NOT NULL
user
- cid — varchar(36) — Primary key — NOT NULL
- id — varchar(36) — NOT NULL
- username — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- salt — binary(255) — NOT NULL
- roles — integer — NOT NULL
- profile_name — varchar(255)
- profile_age — integer
- profile_image_path — text
- alarm_permission — bit — NOT NULL
- friend_acceptance — bit — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime