ward-study
Tables (9)
alarms
- alarm_id — bigint
- create_date — datetime(6)
- update_date — datetime(6)
- alarmArgs — json
- alarmType — varchar(255)
- user_id — bigint
attach
- id — bigint
- uuid — varchar(255)
- study_group_id — bigint
- fileName — varchar(255)
- image — bit — NOT NULL
- uploadPath — varchar(255)
- create_date — datetime(6)
- update_date — datetime(6)
comments
- comment_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id
- study_group_id — bigint — Foreign key → study_group.study_group_id — NOT NULL
- email — varchar(255)
- name — varchar(255)
- body — varchar(255)
- create_date — datetime(6)
- update_date — datetime(6)
- filePath — varchar(255)
- imagedata — longblob
- name — varchar(255)
- size — bigint — NOT NULL
- type — varchar(255)
likes
- like_id — bigint
- user_id — bigint
- study_group_id — bigint — NOT NULL
- create_date — datetime(6)
- update_date — datetime(6)
reservation
- reservation_id — bigint
- reservation_token — varchar(255)
- room_id — bigint
- study_group_id — bigint
- register_id — bigint
- start_time — datetime(6)
- end_time — datetime(6)
- is_email_sent — bit
- create_date — datetime(6)
- update_date — datetime(6)
room
- room_id — bigint
- name — varchar(255)
- create_date — datetime(6)
- update_date — datetime(6)
study_group
- study_group_id — bigint
- user_id — bigint
- title — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- create_date — datetime(6)
- update_date — datetime(6)
user_group
- user_group_id — bigint
- user_id — bigint
- study_group_id — bigint
- user_type — varchar(255)
- create_date — datetime(6)
- update_date — datetime(6)
users
- user_id — bigint
- email — varchar(100) — NOT NULL
- name — varchar(255)
- nickname — varchar(255)
- password — varchar(200) — NOT NULL
- deleted — bit
- create_date — datetime(6)
- update_date — datetime(6)
- delete_date — datetime(6)