pirosite
Tables (15)
Applicant
- id — INT — Primary key — NOT NULL — 지원자 PK
- name — VARCHAR(8) — NOT NULL — 이름
- phone — VARCHAR(16) — NOT NULL — 전화번호
- level — INT — NOT NULL — 기수
- major — INT — NOT NULL — 0:전공 1:비전공 2:복수전공
- is_passed — INT — NOT NULL — 0:불합격 1:1차합격 2:최종합격
- certificate — VARCHAR(255) — 졸업장 이미지
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Article
- id — INT — NOT NULL
- chapter_id — INT — Foreign key → Chapter.id — NOT NULL
- order — INT — NOT NULL
Chapter
- id — INT — Primary key — NOT NULL
- order — INT — NOT NULL — 활동 내용
- description — VARCHAR(128) — NOT NULL — 주차
Curriculum
- id — INT — Primary key — NOT NULL
- week — INT — NOT NULL
- topic_2 — VARCHAR(128)
- topic_3 — VARCHAR(128)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Developer
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Applicant.id — NOT NULL — 조 내용
- portfolio_id — INT — NOT NULL
- position — VARCHAR(64) — 활동 사진
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- =개발자(M:N — 중간
FAQ
- id — INT — Primary key — NOT NULL
- number — INT — NOT NULL — 자주하는 답변
- question — VARCHAR(128) — NOT NULL — 기수
- answer — TEXT — NOT NULL — 합격자(is_passed=2)
Gallery
- id — INT — Primary key — NOT NULL
- photo — VARCHAR(255) — NOT NULL
- updated_at — DATETIME — NOT NULL
Interview
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Applicant.id — NOT NULL — 프로젝트 로고
- question_id — INT — Foreign key → Question.id — NOT NULL
- intro — VARCHAR(128) — 프로젝트 이름
- profile_img — VARCHAR(255) — 한 줄 소개
- answer_1 — TEXT
- answer_2 — TEXT
- answer_3 — TEXT
- answer_4 — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Meeting
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Applicant.id — NOT NULL — 면접 일자
- schedule — DATETIME — NOT NULL — 순번
Portfolio
- id — INT — Primary key — NOT NULL
- level — INT — NOT NULL — 합격자(is_passed=2)
- logo — VARCHAR(255) — NOT NULL — ame VARCHAR(64) NOT NULL COMMENT '장 번호
- intro — VARCHAR(128) — 장 이름
- text_1 — TEXT
- text_2 — TEXT
- text_3 — TEXT
- text_4 — TEXT
- github — VARCHAR(256) — 조 번호
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
PortfolioSubject
- id — INT — Primary key — NOT NULL
- portfolio_id — INT — Foreign key → Portfolio.id — NOT NULL
- sub_1 — VARCHAR(48)
- sub_2 — VARCHAR(48)
- sub_3 — VARCHAR(48)
- sub_4 — VARCHAR(48)
Question
- id — INT — Primary key — NOT NULL
- level — INT — NOT NULL — 프로필사진
- question_1 — VARCHAR(256)
- question_2 — VARCHAR(256)
- question_3 — VARCHAR(256)
- question_4 — VARCHAR(256)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ScreenShot
- id — INT — Primary key — NOT NULL
- portfolio_id — INT — Foreign key → Portfolio.id — NOT NULL
- screenshot — VARCHAR(255)
Setting
- id — INT — Primary key — NOT NULL
- last_recruit_start_day — DATETIME
- last_recruit_end_day — DATETIME
- last_result1_day — DATETIME
- last_meeting_start_day — DATE
- last_meeting_end_day — DATE
- last_result2_day — DATETIME
- last_workshop_day — DATE
- open_process_day — DATETIME
- level — INT
- recruit_start_day — DATETIME
- recruit_end_day — DATETIME
- result1_day — DATETIME
- meeting_inform_url — VARCHAR(256)
- meeting_place — VARCHAR(256)
- meeting_start_day — DATE
- meeting_end_day — DATE
- result2_day — DATETIME
- passed_inform_url — VARCHAR(256)
- workshop_day — DATE
Sponsor
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- logo — VARCHAR(255) — NOT NULL
- website — VARCHAR(200)