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 (데이터변경일)