dd
Tables (8)
BOARD
- BOARD_NUM — NUMBER — Primary key — NOT NULL
- BOARD_ID — VARCHAR2(20) — NOT NULL
- BOARD_DATE — DATE — NOT NULL
- BOARD_TITLE — VARCHAR2(20) — NOT NULL
- BOARD_CONTENT — VARCHAR2(20) — NOT NULL
CAREER_FILE
- FILE_ID — VARCHAR2(20) — NOT NULL
- FILE_NAME — VARCHAR2(20) — NOT NULL
- FILE_CONTENT — BLOB — NOT NULL
COMP_INFO
- COMP_ID — varchar2(20) — NOT NULL
- COMP_NAME — varchar2(20) — NOT NULL
- NEEDS_TECH — varchar2(20) — NOT NULL
- NEEDS_SKILL — varchar2(20) — NOT NULL
LOG
- LOG_ID — VARCHAR2(20) — NOT NULL
- LOG_BOARD_NUM — NUMBER — NOT NULL
- LOG_DATE — DATE — NOT NULL
MEMBER
- ID — VARCHAR2(20) — Primary key — NOT NULL
- ID_CODE — NUMBER — NOT NULL
- PWD — VARCHAR2(20) — NOT NULL
- NAME — VARCHAR2(20) — NOT NULL
- PHONE — VARCHAR2(20)
- EMAIL — VARCHAR2(20)
- ADDRESS — VARCHAR2(20)
- REG_DATE — DATE — NOT NULL
- ROLE — NUMBER — NOT NULL
MY_CAREER_INFO
- CAREER_ID — VARCHAR2(20) — NOT NULL
- EXPR_COMP_NAME — VARCHAR2(20) — NOT NULL
- EXPR_PROJECT — VARCHAR2(20) — NOT NULL
- EXPR_POSITION — VARCHAR2(20)
- EXPR_PERIOD — VARCHAR2(20) — NOT NULL
- TECH_TREE — VARCHAR2(20) — NOT NULL
- SKILL_TREE — VARCHAR2(20) — NOT NULL
- FILE_NAME — VARCHAR2(20) — NOT NULL
SKILL_KIND
- SKILL_CODE — VARCHAR2(20) — Primary key — NOT NULL
- SKILL_NAME — VARCHAR2(20) — NOT NULL
TECH_CLASS
- TECH_CODE — VARCHAR2(20) — Primary key — NOT NULL
- TECH_NAME — VARCHAR2(20) — NOT NULL