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)

        VOTER (Untitled4)