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