ryc

Tables (10)

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
  • announcement_id — varchar(255) — Foreign key → announcements.id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

announcement_images

  • image_order — int — Primary key — NOT NULL
  • announcement_id — varchar(255) — Foreign key → announcements.id — NOT NULL
  • image_url — varchar(255)
  • thumbnail_url — varchar(255)

announcement_tags

  • tag_order — int — Primary key — NOT NULL
  • announcement_entity_id — varchar(255) — Foreign key → announcements.id — NOT NULL
  • label — varchar(255)

announcements

  • id — varchar(255) — Primary key — NOT NULL
  • club_id — varchar(255) — Foreign key → clubs.id — NOT NULL
  • created_at — datetime(6)
  • 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)
  • check — (`announcement_type` between 0 and 1)

application_personal_info_questions

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

application_pre_questions

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

application_questions

  • application_question_order — int — Primary key — NOT NULL
  • announcement_application_entity_id — varchar(255) — Foreign key → announcement_application.id — 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) — Primary key — 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)