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