ryc

Tables (14)

admins

  • id — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • admin_default_role — enum
  • deleted — bit
  • email — varchar(255)
  • image_url — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • thumbnail_url — varchar(255)

announcement_application

  • id — varchar(255) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • announcement_id — varchar(255)

announcement_images

  • announcement_entity_id — varchar(255) — Primary key — NOT NULL
  • image_order — int — Primary key — NOT NULL
  • image_url — varchar(255)
  • thumbnail_url — varchar(255)

announcement_tags

  • announcement_entity_id — varchar(255) — Primary key — NOT NULL
  • tag_order — int — Primary key — NOT NULL
  • label — varchar(255)

announcements (동아리 공고)

  • id (Key) — Primary key — NOT NULL
  • application_period_start_date (Field)
  • applcation_period_end_date (Field2)
  • document_result_start_date (Field3)
  • document_result_end_date (Field4)
  • Field5
  • Field6

announcements

  • id — varchar(255) — Primary key — NOT NULL
  • updated_at — datetime(6)
  • activity_period — varchar(255)
  • application_period_end_date — datetime(6)
  • application_period_start_date — datetime(6)
  • document_result_period_end_date — datetime(6)
  • document_result_period_start_date — datetime(6)
  • final_result_period_end_date — datetime(6)
  • final_result_period_start_date — datetime(6)
  • interview_period_end_date — datetime(6)
  • interview_period_start_date — datetime(6)
  • announcement_type — tinyint
  • detail_description — text
  • has_interview — bit
  • is_deleted — bit
  • number_of_people — varchar(255)
  • summary_description — varchar(255)
  • target — varchar(255)
  • title — varchar(255)
  • club_id — varchar(255)
  • check — (`announcement_type` between 0 and 1)
  • created_at — datetime(6)

application_personal_info_questions

  • announcement_application_entity_id — varchar(255) — Primary key — NOT NULL
  • personal_info_question_order — int — Primary key — NOT NULL
  • personal_info_questions — tinyint
  • check — (`personal_info_questions` between 0 and 4)

application_pre_questions

  • announcement_application_entity_id — varchar(255) — Primary key — NOT NULL
  • pre_question_order — int — Primary key — NOT NULL
  • is_required — bit
  • label — varchar(255)
  • options — text
  • question_type — enum

application_questions

  • announcement_application_entity_id — varchar(255) — Primary key — NOT NULL
  • application_question_order — int — Primary key — NOT NULL
  • is_required — bit
  • label — varchar(255)
  • options — text
  • question_type — enum

club_tags

  • id — varchar(255) — NOT NULL
  • name — varchar(255)
  • club_id — varchar(255)

clubs

  • id — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • category — enum
  • deleted — bit
  • description — text
  • image_url — varchar(255)
  • name — varchar(255)
  • thumbnail_url — varchar(255)

personal_info_questions (인적사항 질문)

  • Key — Primary key — NOT NULL
  • type (질문 타입) — ENUM
  • order (순서) — int

question_choice (객관식 보기)

  • question_id (Key2) — varchar — Foreign key → questions.id — NOT NULL
  • label (보기) — varchar

questions (질문)

  • id (Key) — varchar — Primary key — NOT NULL
  • type (질문 타입) — enum
  • label (질문) — varchar
  • required (필수사항) — BOOL
  • order (순서) — int