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)