DEVCA_ERD

테이블 (25)

CAREER (Untitled5)

  • CAREER_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
  • PROFILE_SEQ (FK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • COMPANY_NAME (Field) — VARCHAR2
  • DUTY (Field2) — VARCHAR2
  • DAY_OF_ENTRY (Field3) — VATCHAR2
  • DATE_OF_DEPARTURE (Field4) — VARCHAR2
  • STACK (Field5) — VARCHAR2
  • DETAIL_OPERATION (Field6) — NUMBER
  • LINK (Field7) — VARCHAR2
  • EXPLANATION (Field8) — VARCHAR2

JD (Untitled13)

  • Field
  • Field2

KAKAO LOGIN TABLE (Untitled15)

  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • KAKAO_ID (Field) — VARCHAR2
  • KAKAO_NICKNAME (Field2) — VARCHAR2

NAVER LOGIN TABLE (CopyOfUntitled15)

  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • NAVER_ID (Field) — VARCHAR2
  • NAVER_NICKNAME (Field2) — VARCHAR2

PROFILE (Untitled4)

  • PROFILE_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • Field

PROJECT (Untitled6)

  • PROJECT_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
  • PROFILE_SEQ (FK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • PROJECT_NAME (Field) — VARCHAR2
  • PRODUCTION_YEAR (Field2) — NUMBER
  • ONELINE_EX (Field3) — VARCHAR2
  • TEAM (Field4) — VARCHAR2
  • MEMBER (Field5) — VARCHAR2
  • USE_STACK (Field6) — VARCHAR2
  • DETAIL (Field7) — VARCHAR2
  • STORAGE_LINK (Field8) — VARCHAR2

강의게시판 (Untitled)

  • LECTURE_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
  • LECTURE_TITLE (KEY) — VARCHAR2
  • LECTURE_IMG (Field) — VARCHAR2
  • LECTURE_CONTENT (Field2) — VARCHAR2
  • LECTURE_READCOUNT (Field3) — NUMBER
  • LECTURE_PAYFLAG (Field6) — VARCHAR2
  • LECTURE_DELFLAG (Field7) — VARCHAR2
  • LECTURE_LATITUDE (Field4) — NUMBER
  • LECTURE_LOGITUDE (Field5) — NUMBER
  • LECTURE_ADDRESS (Field8) — VARCHAR2

강좌보관함 (Untitled9)

  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • LECTURE_SEQ (PK) — NUMBER — 외래 키 → 강의게시판.LECTURE_SEQ — NOT NULL

상세 업무 및 성과 (CopyOfUntitled67)

  • PERFORMANCE_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
  • CAREER_SEQ (FK) — NUMBER — 외래 키 → CAREER.CAREER_SEQ — NOT NULL
  • PERFORMANCE (Field) — VARCHAR2
  • START_DATE (Field2) — DATE
  • END_DATE (Field3) — DATE
  • DETAIL_CONTEXT (Field4) — VARCHAR2

설문조사 (Untitled7)

  • SURVEY_SEQ (Key) — 기본 키 — NOT NULL
  • /MEMBER_SEQ (Key2) — 기본 키 — NOT NULL
  • MEMBER_SEQ (Key3) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL

수상경력/자격증 (CopyOfUntitled65)

  • CERTIFICATE_SEQ (Key) — NUMBER — 기본 키 — NOT NULL
  • PROFILE_SEQ (FK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key2) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • CERTIFICATE (Field) — VARCHAR2
  • CERTIFICATE_DATE (Field2) — DATE
  • CERTIFICATE_LINK (Field3) — VARCHAR2
  • CERTIFICATE_EX (Field4) — VARCHAR2

스터디 참여자 (Untitled14)

  • STUDY_SEQ (PK) — NUMBER — 외래 키 → 스터디게시판.STUDY_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • STUDY_MEMBER_LOGFLAG (Field) — VARCHAR2
  • Field2

스터디게시판 (Untitled11)

  • STUDY_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • STUDY_NAME (Field) — VARCHAR2
  • STUDY_CONTENT (Field2) — VARCHAR2
  • STUDY_DATE (Field3) — DATE
  • STUDY_LOGITUDE (Field4) — NUMBER
  • STUDY_LATITUDE (Field5) — NUMBER
  • STUDY_ADDRESS (Field6) — VARCHAR2
  • STURY_READCOUNT (Field7) — NUMBER
  • STURY_DELFLAG (Field8) — VARCHAR2

스터디게시판 댓글 (CopyOfUntitled10)

  • STUDY_MEMBER_SEQ (PK) — 기본 키 — NOT NULL
  • STUDY_SEQ (PK2) — NUMBER — 외래 키 → 스터디게시판.STUDY_SEQ — NOT NULL
  • STUDY_COMMENT_CONTEXT (Field) — VARCHAR2
  • STUDY_COMMENT_CREATEDATE (Field2) — VARCHAR2
  • STUDY_COMMENT_WRITER (Field3) — VARCHAR2
  • STUDY_COMMENT_DEPTH (Field4) — NUMBER
  • STUDY_COMMENT_GROUPNO (Field5) — NUMBER
  • STUDY_COMMENT_GROUP_ORDER (Field6) — NUMBER

어학시험 (CopyOfCopyOfUntitled62)

  • PROFILE_SEQ (PK2) — NUMBER — 외래 키 → 외국어.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → 외국어.MEMBER_SEQ — NOT NULL
  • TEST_NAME (Field) — VARCHAR2
  • GRADE (Field2) — VARCHAR2

연봉 (CopyOfUntitled66)

  • PROFILE_SEQ (PK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • INCOME (Field) — NUMBER

외국어 (CopyOfUntitled62)

  • PROFILE_SEQ (FK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • LANGUAGE (Field) — NUMBER

저장소 (CopyOfUntitled64)

  • PROFILE_SEQ (PK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • STORAGE_LINK (Field) — VARCHAR2
  • HOMEPAGE_LINK (Field2) — VARCHAR2

주요 기술 (CopyOfUntitled6)

  • PROFILE_SEQ (PK2) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key2) — NUMBER — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • SKILL_ONE (Field) — VARCHAR2
  • SKILL_TWO (Field2) — VARCHAR2
  • SKILL_THREE (Field3) — VARCHAR2

직군 (Untitled8)

  • PROFILE_SEQ (PK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • LINE_OF_WORK_ONE (Field) — VARCHAR2
  • LINE_OF_WORK_TWO (Field2) — VARCHAR2
  • LINE_OF_WORK_THREE (Field3) — VARCHAR2

캘린더 (Untitled12)

  • CALENDER_SEQ (PK) — 기본 키 — NOT NULL
  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • CALENDER_DATE (Field)
  • CALENDER_SUCCESS (Field2) — NUMBER

학력 (CopyOfUntitled63)

  • ACADEMI_ BACKGROUND (PK) — NUMBER — 기본 키 — NOT NULL
  • PROFILE_SEQ (FK) — NUMBER — 외래 키 → PROFILE.PROFILE_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — 외래 키 → PROFILE.MEMBER_SEQ — NOT NULL
  • SCHOOL_NAME (NN) — VARCHAR2
  • MAJOR (Field) — VARCHAR2
  • DAY_OF_SCHOOL (Field2) — DATE
  • END_OF_SCHOOL (Field3) — DATE
  • CREDIT (Field4) — NUMBER
  • EXPLANATION (Field5) — VARCHAR2

회원 (Untitled3)

  • MEMBER_SEQ (Key) — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID (Field9) — VARCHAR2
  • MEMBER_PW (Field) — VARCHAR2
  • MEMBER_NAME (Field8) — VARCHAR2
  • MEMBER_EMAIL (Field3) — VARCHAR2
  • MEMBER_PHONE (Field4) — VARCHAR2
  • MEMBER_ENABLED (Field6) — VARCHAR2
  • MEMBER_ROLE (Field7) — VARCHAR2
  • MEMBER_LOGOUT_DATE (Field10) — DATE
  • MEMBER_CREATE_DATE (Field2) — DATE

후기게시판 (Untitled2)

  • REVIEW_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
  • LECTURE_SEQ (PK2) — NUMBER — 외래 키 → 강의게시판.LECTURE_SEQ — NOT NULL
  • REVIEW_TITLETAB (Field6) — NUMBER
  • REVIEW_CONTENT (Field2) — VARCHAR2
  • REVIEW_REGDATE (Field3) — DATE

후기댓글 (Untitled10)

  • COMMENT_SEQ (PK) — 기본 키 — NOT NULL
  • REVIEW_SEQ (PK2) — NUMBER — 외래 키 → 후기게시판.REVIEW_SEQ — NOT NULL
  • MEMBER_SEQ (Key) — NUMBER — 외래 키 → 후기게시판.MEMBER_SEQ — NOT NULL
  • COMMENT_CONTEXT (Field) — VARCHAR2
  • COMMENT_CREATEDATE (Field2) — VARCHAR2
  • COMMENT_WRITER (Field3) — VARCHAR2
  • COMMENT_DEPTH (Field4) — NUMBER
  • COMMENT_GROUPNO (Field5) — NUMBER
  • COMMENT_GROUP_ORDER (Field6) — NUMBER