사원관리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)