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