CoCoder
Tables (7)
TB_CODER (코더)
- CID (Key) — VAR_32 — Primary key — NOT NULL
- UID (Key2) — VAR_32 — Foreign key → TB_USER.UID — NOT NULL
- TID (Key3) — VAR_32 — Foreign key → TB_USER.TID — NOT NULL
- SKILL_STACK (SID_LIST) — Foreign key → TB_SKILL.SID — NOT NULL
- INTRO (개인소개)
- WORK_YEAR (연차)
- ROLE (역할)
- DEFAULT_YN (대표이력서 여부)
- CREATE_DATE (데이터생성일)
- UPDATE_DATE (데이터변경일)
TB_LIKE (좋아요)
- LID (Key) — VAR_32 — Primary key — NOT NULL
- TID (Key2) — VAR_32 — Foreign key → TB_TEAM.TID — NOT NULL
- UID (Key3) — VAR_32 — Foreign key → TB_USER.UID — NOT NULL
- TID (Key4) — VAR_32 — Foreign key → TB_USER.TID — NOT NULL
- CATEGORY (Field)
- CREATE_DATE (데이터생성일)
- UPDATE_DATE (데이터변경일)
TB_LOG (신청이력)
- LOG_ID (Key) — VAR_32 — Primary key — NOT NULL
- TID (Key2) — VAR_32 — Foreign key → TB_TEAM.TID — NOT NULL
- CID (Key3) — VAR_32 — Foreign key → TB_CODER.CID — NOT NULL
- UID (Key22) — VAR_32 — Foreign key → TB_CODER.UID — NOT NULL
- TID (Key32) — VAR_32 — Foreign key → TB_CODER.TID — NOT NULL
- STATUS (상태)
- CATEGORY (분류)
- CREATE_DATE (데이터생성일)
- UPDATE_DATE (데이터변경일)
TB_SKILL (기술)
- SID (Key) — Primary key — NOT NULL
- SKILL_NAME (기술명)
- IMG_ID (이미지ID)
- CREATE_DATE (데이터생성일)
- UPDATE_DATE (데이터변경일)
TB_TEAM (팀)
- TID (Key) — VAR_32 — Primary key — NOT NULL
- LEADER (UID) — Foreign key → TB_USER.UID — NOT NULL
- TEAM_NAME (팀명)
- LOCATION (팀지역)
- INTRO (팀소개)
- CREATE_DATE (데이터생성일)
- UPDATE_DATE (데이터변경일)
TB_TEAM_RECRUIT (모집)
- RID (Key2) — VAR_32 — Primary key — NOT NULL
- TID (Key) — VAR_32 — Foreign key → TB_TEAM.TID — NOT NULL
- SKILL_STACK (SID_LIST) — Foreign key → TB_SKILL.SID — NOT NULL
- REQ_NO (필요인원)
- CUR_NO (현재인원)
- CATEGORY (카테고리)
- RECRUIT_INTRO (소개)
- ON_OFF (협업방식)
TB_USER (사용자)
- UID (TB_USER_PK) — VAR_32 — Primary key — NOT NULL
- USER_ID (로그인아이디) — Primary key — NOT NULL
- TID (소속팀) — VAR_32 — Foreign key → TB_TEAM.TID — NOT NULL
- PW (비밀번호)
- NICK_NAME (별명)
- PHONE_NUMBER (전화번호)
- GENDER (성별)
- USER_EMAIL (사용이메일)
- USER_TYPE (회원가입방식)
- CREATE_DATE (데이터생성일)
- UPDATE_DATE (데이터변경일)