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)