songyeoin-v3
Tables (19)
attendance
- attendance_id — bigint — Primary key — NOT NULL
- date — date — NOT NULL
- course_id — bigint — NOT NULL
- enroll_date — datetime(6) — NOT NULL
- enter_time — datetime(6)
- exit_time — datetime(6)
- member_id — bigint — NOT NULL
- modified_date — datetime(6) — NOT NULL
- period_id — bigint — NOT NULL
- memo — varchar(255)
- status — enum('PRESENT','ABSENT','LATE','EARLY_LEAVE','PENDING') — NOT NULL
club
- club_id — bigint — Primary key — NOT NULL
- end_time — time(6) — NOT NULL
- participant_count — int — NOT NULL
- reg_date — date
- start_time — time(6) — NOT NULL
- study_date — date — NOT NULL
- checker_id — bigint
- course_id — bigint — NOT NULL
- writer_id — bigint — NOT NULL
- content — varchar(100)
- check_message — varchar(255)
- club_name — varchar(255) — NOT NULL
- contact_number — varchar(255)
- participants — varchar(255) — NOT NULL
- check_status — enum('N','W','Y') — NOT NULL
club_file
- club_file_id — bigint — Primary key — NOT NULL
- club_id — bigint — Foreign key → club.club_id
- file_id — bigint — Foreign key → files.id
course
- course_id — bigint — Primary key — NOT NULL
- end_date — date — NOT NULL
- enroll_date — date — NOT NULL
- modified_date — date
- room_name — varchar(4)
- start_date — date — NOT NULL
- admin_id — bigint — NOT NULL
- deleted_by — bigint
- schedule_id — bigint
- admin_name — varchar(30) — NOT NULL
- teacher_name — varchar(30)
- name — varchar(50) — NOT NULL
- description — varchar(100)
- status — enum('N','Y') — NOT NULL
developer_responses
- id — bigint — Primary key — NOT NULL
- support_id — bigint — Foreign key → support.id — NOT NULL
- response_content — text — NOT NULL
- developer_id — varchar(255)
- developer_name — varchar(255)
- created_at — timestamp
- updated_at — timestamp
enroll
- id — bigint — Primary key — NOT NULL
- course_id — bigint
- deleted_by — bigint
- member_id — bigint
files
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- deleted_at — datetime(6)
- deleted_by — bigint — Foreign key → member.id
- size — bigint — NOT NULL
- updated_at — datetime(6)
- uploaded_by — bigint — Foreign key → member.id
- mime_type — varchar(255) — NOT NULL
- object_key — varchar(255) — NOT NULL
- original_name — varchar(255) — NOT NULL
- path — varchar(255) — NOT NULL
- status — enum('ACTIVE','DELETED','TEMPORARY') — NOT NULL
holidays
- holidays_id — bigint — Primary key — NOT NULL
- date — date — NOT NULL
- created_at — datetime(6) — NOT NULL
- name — varchar(100) — NOT NULL
- type — enum('HOLIDAY','SUBSTITUTE_HOLIDAY','WEEKDAY','WEEKEND') — NOT NULL
journal
- id — bigint — Primary key — NOT NULL
- education_date — date — NOT NULL
- course_id — bigint — Foreign key → course.course_id — NOT NULL
- created_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- updated_at — datetime(6)
- content — text — NOT NULL
- title — varchar(255) — NOT NULL
journal_files
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- file_id — bigint — Foreign key → files.id
- journal_id — bigint — Foreign key → journal.id
- updated_at — datetime(6)
jwt_blacklist
- id — bigint — Primary key — NOT NULL
- device_info — varchar(255)
- expiry_date — datetime(6) — NOT NULL
- ip_address — varchar(255)
- token_id — varchar(255) — NOT NULL
- token_type — varchar(255) — NOT NULL
- user_agent — varchar(255)
member
- id — bigint — Primary key — NOT NULL
- password_change_required — bit(1) — NOT NULL
- deleted_by — bigint
- enroll_date — datetime(6)
- birthday — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- profile_url — varchar(255)
- username — varchar(255) — NOT NULL
- check_status — enum('N','W','Y') — NOT NULL
- role — enum('ADMIN','STUDENT') — NOT NULL
notice
- id — bigint — Primary key — NOT NULL
- is_pinned — bit(1) — NOT NULL
- course_id — bigint — Foreign key → course.course_id
- deleted_by — bigint
- member_id — bigint — Foreign key → member.id — NOT NULL
- modify_date — datetime(6)
- reg_date — datetime(6)
- view_count — bigint — NOT NULL
- content — text — NOT NULL
- title — varchar(255) — NOT NULL
notice_file
- id — bigint — Primary key — NOT NULL
- file_id — bigint — Foreign key → files.id — NOT NULL
- notice_id — bigint — Foreign key → notice.id — NOT NULL
period
- period_id — bigint — Primary key — NOT NULL
- day_of_week — varchar(3) — NOT NULL
- end_time — time(6) — NOT NULL
- name — varchar(3) — NOT NULL
- start_time — time(6) — NOT NULL
- course_id — bigint — NOT NULL
- deleted_by — bigint
- schedule_id — bigint — NOT NULL
refresh_token
- id — bigint — Primary key — NOT NULL
- device_info — varchar(255)
- expiry_date — datetime(6) — NOT NULL
- ip_address — varchar(255)
- member_id — bigint — NOT NULL
- token — varchar(255) — NOT NULL
- user_agent — varchar(255)
s3file
- id — bigint — Primary key — NOT NULL
- file_size — bigint — NOT NULL
- bucket_name — varchar(255) — NOT NULL
- file_name — varchar(255) — NOT NULL
- file_url — varchar(255) — NOT NULL
- s3key — varchar(255) — NOT NULL
schedule
- schedule_id — bigint — Primary key — NOT NULL
- enroll_date — date — NOT NULL
- modified_date — date — NOT NULL
- course_id — bigint — NOT NULL
- deleted_by — bigint
support
- id — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- deleted_by — bigint
- is_confirmed — bit(1) — NOT NULL
- modify_date — datetime(6)
- reg_date — datetime(6)
- title — varchar(255) — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL