사원관리ERD

테이블 (9)

BOARDS (Untitled9)

  • BOARD_SEQ (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
  • USER_SEQ (Key3) — VARCHAR2(10) — 외래 키 → INFO_USER.USER_SEQ — NOT NULL
  • BOARD_TITLE (Field) — VARCHAR2(30)
  • CONTENT (Field2) — CLOB
  • BOARD_REG_DATE (Field3) — Date
  • CATEGORI_SEQ (Field4) — VARCHAR2(10)

CODE_DETAIL (Untitled5)

  • DTLCODE (Key) — VARCHAR(10) — 기본 키 — NOT NULL
  • DCODE (Key2) — VARCHAR(10) — 외래 키 → CODE_MST.DCODE — NOT NULL
  • DTLCODE_NM (Field) — VARCHAR2(100)

CODE_MST (Untitled4)

  • DCODE (Key) — VARCHAR(10) — 기본 키 — NOT NULL
  • DCODE_NM (Field) — VARCHAR(20)

COMMENTS (Untitled10)

  • COMMENT_SEQ (Key) — VARCHAR(10) — 기본 키 — NOT NULL
  • BOARD_SEQ (Key2) — VARCHAR2(10) — 외래 키 → BOARDS.BOARD_SEQ — NOT NULL
  • PARENT_COMMENT_SEQ (Field) — VARCHAR2(10)
  • COMMENT_TEXT (Field2) — VARCHAR2(300)
  • COMMENT_REG_DATE (Field3) — Date

INFO_PROJECT (Untitled2)

  • PRJ_SEQ (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
  • PRJ_NM (Field) — VARCHAR2(100)
  • CUSTOMER_CD (Field2) — VARCHAR2(10)
  • PRJ_START_DATE (Field3) — VARCHAR2(8)
  • PRJ_END_DATE (Field4) — VARCHAR2(8)
  • PRJ_DETAIL (Field5) — VARCHAR2(100)

INFO_PROJECT_SKILL (Untitled7)

  • PRJ_SEQ (Key) — VARCHAR2(10) — 외래 키 → INFO_PROJECT.PRJ_SEQ — NOT NULL
  • DTLCODE (Field) — VARCHAR2(10)

INFO_USER (Untitled)

  • USER_SEQ (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
  • USER_NM (Field) — VARCHAR2(50)
  • USER_ID (Field2) — VARCHAR2(50)
  • USER_PW (Field3) — VARCHAR2(64)
  • GENDER_CD (Field4) — VARCHAR2(10)
  • PHONE_NUMBER (Field5) — VARCHAR2(50)
  • REG_DATE (Field6) — VARCHAR2(8)
  • POS_CD (Field7) — VARCHAR2(10)
  • SKILL_RANK_CD (Field8) — VARCHAR2(10)
  • EMAIL (Field9) — VARCHAR2(100)
  • ADDRESS (Field10) — VARCHAR2(100)
  • WORK_STATE_CD (Field11) — VARCHAR2(10)
  • USER_STATE_CD (Field12) — VARCHAR2(10)
  • USER_REG_DATE (Field13) — Date
  • USER_IMAGE (Field14) — VARCHAR2(100)

INFO_USER_PROJECT (Untitled3)

  • USER_SEQ (Key) — VARCHAR2(10) — 외래 키 → INFO_USER.USER_SEQ — NOT NULL
  • PRJ_SEQ (Key2) — VARCHAR2(10) — 외래 키 → INFO_PROJECT.PRJ_SEQ — NOT NULL
  • UP_START_DATE (Field) — VARCHAR2(8)
  • UP_END_DATE (Field2) — VARCHAR2(8)
  • ROLE_CD (Field3) — VARCHAR2(30)

INFO_USER_SKILL (Untitled6)

  • USER_SEQ (Key) — VARCHAR2(10) — 외래 키 → INFO_USER.USER_SEQ — NOT NULL
  • DTLCODE (Field) — VARCHAR2(10)