test
Tables (24)
tbl_assigned
- task_id — BIGINT — Foreign key → tbl_task.task_id — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
tbl_board
- board_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- desc — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- views — INT — NOT NULL
tbl_board_file
- board_id — BIGINT — Foreign key → tbl_board.board_id — NOT NULL
- file_id — BIGINT — Foreign key → tbl_file.file_id — NOT NULL
tbl_board_like
- board_id — BIGINT — Foreign key → tbl_board.board_id — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
tbl_chat_1
- chat_id — BIGINT — Primary key — NOT NULL
- study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tbl_file
- file_id — BIGINT — Primary key — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
tbl_location
- location_id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → tbl_location.location_id
- name — VARCHAR(255) — NOT NULL
- type — ENUM('CITY', 'TOWN') — NOT NULL
tbl_member
- study_member_id — BIGINT — Primary key — NOT NULL
- study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- message — TEXT — NOT NULL
- status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
- request_at — TIMESTAMP — NOT NULL
- update_at — TIMESTAMP — NOT NULL
tbl_notifications
- notification_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- type — ENUM('NEW_MEMBER_REQUEST', 'COMMENT_REPLY', 'TASK_REMINDER', 'SYSTEM') — NOT NULL
- message — TEXT — NOT NULL
- url — VARCHAR(255) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tbl_position
- position_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
tbl_profile
- profile_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- desc — TEXT — NOT NULL
- profile_url — VARCHAR(255) — NOT NULL
tbl_profile_file
- file_id — BIGINT — Foreign key → tbl_file.file_id — NOT NULL
- profile_id — BIGINT — Foreign key → tbl_profile.profile_id — NOT NULL
tbl_profile_position
- position_id — BIGINT — Foreign key → tbl_position.position_id — NOT NULL
- profile_id — BIGINT — Foreign key → tbl_profile.profile_id — NOT NULL
tbl_profile_stack
- stack_id — BIGINT — Foreign key → tbl_stack.stack_id — NOT NULL
- profile_id — BIGINT — Foreign key → tbl_profile.profile_id — NOT NULL
tbl_reply
- reply_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → tbl_board.board_id — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- desc — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tbl_stack
- stack_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- desc — VARCHAR(255) — NOT NULL
- described — TEXT — NOT NULL
- assort — VARCHAR(255) — NOT NULL
tbl_study
- study_id — BIGINT — Primary key — NOT NULL
- leader_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- desc — TEXT — NOT NULL
- is_online — TINYINT(1) — NOT NULL
- type — ENUM('STUDY', 'PROJECT') — NOT NULL
- is_opened — TINYINT(1) — NOT NULL
- min_cap — TINYINT(1) — NOT NULL
- max_cap — TINYINT(1) — NOT NULL
- start_at — TIMESTAMP — NOT NULL
- end_at — TIMESTAMP — NOT NULL
- location_id — BIGINT — Foreign key → tbl_location.location_id
- views — INT — NOT NULL
tbl_study_like
- study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
tbl_study_position
- position_id — BIGINT — Foreign key → tbl_position.position_id — NOT NULL
- study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
tbl_study_stack
- stack_id — BIGINT — Foreign key → tbl_stack.stack_id — NOT NULL
- study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
tbl_submission
- submission_id — BIGINT — Primary key — NOT NULL
- task_id — BIGINT — Foreign key → tbl_task.task_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- views — INT — NOT NULL
- desc — TEXT — NOT NULL
- title — VARCHAR(255) — NOT NULL
tbl_submission_file
- submission_id — BIGINT — Foreign key → tbl_submission.submission_id — NOT NULL
- file_id — BIGINT — Foreign key → tbl_file.file_id — NOT NULL
tbl_task
- task_id — BIGINT — Primary key — NOT NULL
- study_id — BIGINT — Foreign key → tbl_study.study_id — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- desc — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- type — ENUM('ASSIGNMENT', 'PROJECT', 'ETC') — NOT NULL
- status — ENUM('NOT_STARTED', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
- start_at — TIMESTAMP
- end_at — TIMESTAMP
tbl_user
- user_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- login_type — ENUM('EMAIL', 'KAKAO', 'NAVER') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE', 'BLOCKED') — NOT NULL
- role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
- password — VARCHAR(255) — NOT NULL