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