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