Bitfinal
Tables (14)
BOARD (게시판)
- BOARD_SEQ (게시글번호) — NUMBER(8) — Primary key — NOT NULL
- GROUP_INFO_SEQ (그룹정보SEQ) — NUMBER(8) — Foreign key → GROUP_INFO.GROUP_INFO_SEQ — NOT NULL
- MEMBER_SEQ (Key5) — NUMBER(8) — Foreign key → GROUP_INFO.MEMBER_SEQ — NOT NULL
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_BIG_SEQ — NOT NULL
- CATEGORY (게시판분류) — NUMBER(1) — 0-default, 1-자유게시판, 2-자료실, 3-투표
- TITLE (글제목) — VARCHAR2(100)
- CONTENT (내용) — VARCHAR2(1000)
- WRITEDATE (작성일) — DATE
- READCOUNT (조회수) — NUMBER(8)
- IMAGE (이미지경로) — VARCHAR2(100)
- CVSTARTDATE (채용시작일(기업전용)) — DATE
- CVENDDATE (채용마감일(기업전용)) — DATE
- FILENAME (파일명) — VARCHAR2(100)
- DBFILENAME (DB에 저장된 파일명) — VARCHAR2(100)
- DEL (글삭제) — NUMBER(1)
- BOARDAUTH (권한(0개인,1익명,2그룹,3취업) — NUMBER(1)
- CAREER (Field) — VARCHAR2(45)
- EDUCATION (field2\) — VARCHAR2(45)
- WORKING_TYPE (모집분야) — VARCHAR2(45)
- SALARY (급여) — VARCHAR2(45)
- POSITION (모) — VARCHAR2(45)
- WORKING_LOCATION (근무지) — VARCHAR2(45)
BOARD_COMMENT (Untitled6)
- COMMENTSEQ (답글seq) — NUMBER(8) — Primary key — NOT NULL
- BOARD_SEQ (게시글번호) — NUMBER(8) — Foreign key → BOARD.BOARD_SEQ — NOT NULL
- GROUP_INFO_SEQ (그룹정보SEQ) — NUMBER(8) — Foreign key → BOARD.GROUP_INFO_SEQ — NOT NULL
- MEMBER_SEQ (Key5) — NUMBER(8) — Foreign key → BOARD.MEMBER_SEQ — NOT NULL
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Foreign key → BOARD.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → BOARD.INTER_BIG_SEQ — NOT NULL
- GROUP_INFO_SEQ (그룹정보SEQ2) — NUMBER(8) — Foreign key → GROUP_INFO.GROUP_INFO_SEQ — NOT NULL
- MEMBER_SEQ (Key52) — NUMBER(8) — Foreign key → GROUP_INFO.MEMBER_SEQ — NOT NULL
- INTER_SMALL_SEQ (소분류SEQ2) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO2) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_BIG_SEQ — NOT NULL
- MEMBER_SEQ (회원번호) — NUMBER(8) — Foreign key → MEMBER.MEMBER_SEQ — NOT NULL
- REF — NUMBER(2)
- STEP — NUMBER(2)
- DEPTH — NUMBER(2)
- CONTENT (내용) — VARCHAR2(1000)
- WRITEDATE (작성일) — DATE
- DEL (삭제) — NUMBER(1)
CALENDAR (활동요일)
- SCHEDULESEQ (스케쥴SEQ) — NUMBER(8) — Primary key — NOT NULL
- GROUP_INFO_SEQ (그룹정보SEQ) — NUMBER(8) — Foreign key → GROUP_INFO.GROUP_INFO_SEQ — NOT NULL
- MEMBER_SEQ (Key5) — NUMBER(8) — Foreign key → GROUP_INFO.MEMBER_SEQ — NOT NULL
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_BIG_SEQ — NOT NULL
- TITLE (title) — VARCHAR2(100)
- CONTENT (내용) — VARCHAR2(500)
- STARTDATE (시작일) — DATE
- ENDDATE (종료일) — DATE
GROUP_ATTEND (Untitled)
GROUP_INFO (그룹명)
- GROUP_INFO_SEQ (그룹정보SEQ) — NUMBER(8) — Primary key — NOT NULL
- MEMBER_SEQ (Key5) — NUMBER(8) — Foreign key → MEMBER.MEMBER_SEQ — NOT NULL
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Foreign key → INTER_SMALL.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → INTER_SMALL.INTER_BIG_SEQ — NOT NULL
- NAME (그룹명) — VARCHAR2(100)
- AI (그룹설명) — VARCHAR2(1000)
- SMALLINFO (그룹한줄요약) — VARCHAR2(100)
- MAXMEMBER (그룹최대인원수) — NUMBER(2)
- IMAGE (그룹썸네일이미지) — VARCHAR2(1000)
- START_DATE (그룹활동시작일) — DATE
- END_DATE (그룹활동종료일) — DATE
- DEL (그룹삭제) — NUMBER(1)
- GROUP_LOCATION (그룹활동지역) — VARCHAR2(200)
- PERMISSION (그룹개설허가여부) — NUMBER(1)
GROUP_MEMBER (그룹별맴버리스트)
- GROUP_MEMBER_SEQ (그룹맴버SEQ) — MEMBER(8) — Primary key — NOT NULL
- MEMBER_SEQ (회원번호) — NUMBER(8) — Foreign key → MEMBER.MEMBER_SEQ — NOT NULL
- GROUP_INFO_SEQ (그룹정보SEQ) — NUMBER(8) — Foreign key → GROUP_INFO.GROUP_INFO_SEQ — NOT NULL
- MEMBER_SEQ (Key5) — NUMBER(8) — Foreign key → GROUP_INFO.MEMBER_SEQ — NOT NULL
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_BIG_SEQ — NOT NULL
- DEL (맴버삭제) — MEMBER(1)
GROUP_POLL (Untitled2)
GROUP_POLL_SUB (Untitled3)
GROUP_SCHEDULE (그룹스케쥴)
- SCHEDULE_SEQ (스케쥴시퀀스) — NUMBER(8) — Primary key — NOT NULL
- GROUP_INFO_SEQ (그룹정보SEQ) — NUMBER(8) — Foreign key → GROUP_INFO.GROUP_INFO_SEQ — NOT NULL
- MEMBER_SEQ (Key5) — NUMBER(8) — Foreign key → GROUP_INFO.MEMBER_SEQ — NOT NULL
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → GROUP_INFO.INTER_BIG_SEQ — NOT NULL
- SUNDAY (일요일) — NUMBER(1)
- MONDAYG (월요일) — NUMBER(1)
- TUESDAY (화요일) — NUMBER(1)
- WEDNESDAY (수요일) — NUMBER(1)
- THURSDAY (목요일) — NUMBER(1)
- FRIDAY (금요일) — NUMBER(1)
- SATURDAY (토요일) — NUMBER(1)
INTER_BIG (대분류)
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Primary key — NOT NULL
- BIG_NAME (대분류명) — VARCHAR2(50)
INTER_SMALL (소분류)
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Primary key — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → INTER_BIG.INTER_BIG_SEQ — NOT NULL
- SMALL_NAME (소분류명) — VARCHAR2(50)
MEMBER (회원)
- MEMBER_SEQ (회원번호) — NUMBER(8) — Primary key — NOT NULL
- MEMBER_NAME (회원명) — VARCHAR2(50)
- PHONE (휴대폰번호) — VARCHAR2(200)
- ADDRESS (회원주소) — VARCHAR2(200)
- ADDRESS (관심지역) — VARCHAR2(200)
- EMAIL (이메일) — VARCHAR2(50)
- MYMONEY (적립금) — NUMBER(8)
- CV (이력서) — NUMBER(1)
- AUTH (권한) — NUMBER(1)
- COMPANY_INFO (회사정보) — VARCHAR2(1000)
- COMPANY_LOGO (회사로고) — VARCHAR2(2000)
- DEL (회원탈퇴) — NUMBER(1)
- PWD (비밀번호) — VARCHAR2(50)
- BIRTH (생년월일) — VARCHAR2(50)
- GENDER (성별) — NUMBER(1)
MEMBER_INTEREST (회원별흥미)
- INTERESTSEQ (회원흥미SEQ) — NUMBER(8) — Primary key
- INTER_SMALL_SEQ (소분류SEQ) — NUMBER(2) — Foreign key → INTER_SMALL.INTER_SMALL_SEQ — NOT NULL
- INTER_BIG_SEQ (대분류SEQ_NO) — NUMBER(2) — Foreign key → INTER_SMALL.INTER_BIG_SEQ — NOT NULL
- DEL (삭제) — NUMBER(1)