CoCoder

Tables (8)

TB_CODER (코더)

  • CODER_SEQ (Key) — VARCHAR(32) — Primary key — NOT NULL
  • UID (Key2) — VARCHAR(32) — Foreign key → TB_USER.USER_SEQ — NOT NULL
  • SKILL_STACK (SID_LIST) — Foreign key → TB_SKILL.SKILL_SEQ — NOT NULL
  • INTRO (개인소개) — VARCHAR(100)
  • WORK_YEAR (연차) — TINYINT
  • ROLE_ENUM (역할_enum) — STRING — enyum
  • IS_DEFAULT (대표이력서 여부) — TINY INT
  • IS_ACTIVE (코더 활성화 여부) — TINY INT
  • CREATE_DATE (데이터생성일) — DATETIME — NOT NULL
  • UPDATE_DATE (데이터변경일) — DATETIME — NOT NULL

TB_JOIN_TEAM_STUS (팀 가입 상태)

  • JOIN_SEQ (TB_JOIN_TEAM_STUS_PK) — VARCHAR(32) — Primary key — NOT NULL
  • TEAM_ID (TB_TEAM_PK) — VARCHAR(32) — Foreign key → TB_TEAM.TEAM_SEQ — NOT NULL
  • UID (TB_USER_PK) — VARCHAR(32) — Foreign key → TB_USER.USER_SEQ — NOT NULL
  • CREATE_DATE (데이터생성일)
  • UPDATE_DATE (데이터변경일)

TB_LIKE (좋아요)

  • LIKE_SEQ (Key) — Primary key — NOT NULL
  • LIKER (좋아요 한 사람) — VARCHAR(32) — Foreign key → TB_USER.USER_SEQ — NOT NULL
  • LIKEE_USER (좋아요 당한 사람) — VARCHAR(32) — Foreign key → TB_USER.USER_ID — NOT NULL
  • LIKEE_TEAM (좋아요 당한 팀) — VARCHAR(32) — Foreign key → TB_TEAM.TEAM_SEQ — NOT NULL
  • CATEGORY_ENUM (카테고리_enum)
  • CREATE_DATE (데이터생성일) — DATETIME — NOT NULL
  • UPDATE_DATE (데이터변경일) — DATETIME — NOT NULL

TB_LOG (신청이력)

  • LOG_SEQ (Key) — VARCHAR(32) — Primary key — NOT NULL
  • TEAM_ID (TID) — VARCHAR(32) — Foreign key → TB_TEAM.TEAM_SEQ — NOT NULL
  • CODER_ID (CID) — VARCHAR(32) — Foreign key → TB_CODER.CODER_SEQ — NOT NULL
  • STATUS (상태) — STRING — NOT NULL
  • CATEGORY_ENUM (카테고리_enum) — STRING — NOT NULL
  • CREATE_DATE (데이터생성일) — DATETIME — NOT NULL
  • UPDATE_DATE (데이터변경일) — DATETIME — NOT NULL

TB_SKILL (기술)

  • SKILL_SEQ (Key) — INT — Primary key — NOT NULL
  • SKILL_NAME (기술명) — VARCHAR(255) — NOT NULL
  • SKILL_IMG_ID (스킬 이미지) — VARCHAR(32)
  • CREATE_DATE (데이터생성일) — DATETIME — NOT NULL
  • UPDATE_DATE (데이터변경일) — DATETIME — NOT NULL

TB_TEAM (팀)

  • TEAM_SEQ (TB_TEAM_PK) — VARCHAR(32) — Primary key — NOT NULL
  • LEADER (UID) — VARCHAR(32) — Foreign key → TB_USER.USER_SEQ — NOT NULL
  • TEAM_NAME (팀명) — VARCHAR(100) — NOT NULL
  • LOCATION (팀지역) — VARCHAR(100)
  • TEAM_INTRO (팀소개) — VARCHAR(100)
  • IS_ACTIVE (팀 활성화 여부) — TINY INT
  • TEAM_IMG_ID (팀 이미지)
  • CREATE_DATE (데이터생성일) — DATETIME — NOT NULL
  • UPDATE_DATE (데이터변경일) — DATETIME — NOT NULL

TB_TEAM_RECRUIT (팀 모집)

  • RECRUIT_SEQ (Key2) — VARCHAR(32) — Primary key — NOT NULL
  • TEAM_ID (Key) — VARCHAR(32) — Foreign key → TB_TEAM.TEAM_SEQ — NOT NULL
  • SKILL_STACK (SID_LIST) — Foreign key → TB_SKILL.SKILL_SEQ — NOT NULL
  • REQ_NO (필요인원) — TINYINT
  • CUR_NO (현재인원) — TINYINT
  • ROLE_ENUM (역할_enyum) — STRING
  • RECRUIT_INTRO (소개) — STRING
  • ON_OFF (협업방식) — STRING
  • CREATE_DATE (데이터생성일) — DATETIME — NOT NULL
  • UPDATE_DATE (데이터변경일) — DATETIME — NOT NULL

TB_USER (사용자)

  • USER_SEQ (TB_USER_PK) — VARCHAR(32) — Primary key — NOT NULL
  • USER_ID (로그인아이디) — VARCHAR(32) — Primary key — NOT NULL
  • PW (비밀번호) — VARCHAR(255) — NOT NULL
  • NICK_NAME (별명) — VARCHAR(255) — NOT NULL
  • PHONE_NUMBER (전화번호) — INT
  • GENDER (성별) — TINYINT
  • USER_EMAIL (사용이메일) — VARCHAR(255)
  • USER_TYPE (회원가입방식) — TINYINT — NOT NULL
  • USER_IMG_ID (유저 이미지)
  • CREATE_DATE (데이터생성일) — DATETIME — NOT NULL
  • UPDATE_DATE (데이터변경일) — DATETIME — NOT NULL