junior-ship

Tables (8)

BOARD (Untitled)

  • idx (seq) — 인덱스 — Primary key — NOT NULL
  • projectNum (titile) — VCAHR
  • status — VCAHR
  • title (contents) — 이메일
  • content (views)
  • regDay (hearts)
  • regId (Field)
  • views (Field2)
  • heart (Field3)
  • category (Field4)
  • 모집인원 (Field5)
  • 시작예정 (Field6)
  • 연락방법 (Field7)
  • 진행방식 (Field8)

BOARD_REPLY (댓글)

  • idx (Key) — INT — Primary key — NOT NULL
  • parentIdx (Field4) — INT
  • userId (Field) — VCAHR
  • content (Field2) — VCAHR
  • regDay (Field3) — VCAHR

HT_ADMIN (관리자 접속 이력)

  • idx (Key) — INT — Primary key — NOT NULL
  • userId (Field) — VCAHR
  • regDay (Field2) — VCAHR
  • optional (Field3) — VCAHR

POINT_DETAIL (유저 레벨 관리)

  • idx (Key) — INT — Primary key — NOT NULL
  • userId (Field) — VCAHR
  • category (Field2) — VCAHR
  • point (Field3) — INT
  • penalty (Field4) — VCAHR
  • description (Field5) — VCAHR
  • regDay (Field6) — VCAHR

PROJECT (프로젝트)

  • idx (Key) — INT — Primary key — NOT NULL
  • projectNum (Field) — INT
  • status (Field2) — VCAHR
  • regId (Field3) — VCAHR
  • regDay (Field4) — VCAHR

PROJECT_DETAIL (프로젝트 참여 멤버 정보)

  • idx (Key) — INT — Primary key — NOT NULL
  • projectNum (Field) — INT
  • userId (Field2) — VCHAR
  • status (Field3) — VCHAR
  • position (Field4) — VCHAR
  • participation (Field5) — INT

technologyStack (기술 스택)

  • idx (Key) — INT — Primary key — NOT NULL
  • stack (Field) — VACHAR
  • category (Field2) — VACHAR

user (사용자)

  • idx (seq) — 인덱스 — Primary key — NOT NULL
  • user (id) — 이메일 — Primary key — NOT NULL
  • mail — VCAHR
  • nickName (pw)
  • position — 1년 미만, 주니어 , 시니어
  • exp (experienced) — NOT NULL
  • point — 적립금
  • role (Field)
  • Field2