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