kd10_issue

Tables (3)

CATE

  • CATENO — NUMBER(10) — Primary key — NOT NULL
  • GRP — VARCHAR2(30) — NOT NULL
  • NAME — VARCHAR2(30) — NOT NULL
  • CNT — NUMBER(7) — NOT NULL
  • SEQNO — NUMBER(5) — NOT NULL
  • VISIBLE — CHAR(1) — NOT NULL
  • RDATE — DATE — NOT NULL

EMPLOYEE

  • EMPLOYEENO — NUMBER(5) — Primary key — NOT NULL
  • ID — VARCHAR(20) — NOT NULL
  • PASSWORD — VARCHAR(100) — NOT NULL
  • MNAME — VARCHAR(20) — NOT NULL
  • RDATE — DATE — NOT NULL
  • GRADE — NUMBER(2) — NOT NULL

ISSUE

  • ISSUENO — NUMBER(10) — Primary key — NOT NULL
  • TITLE — VARCHAR2(100) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • CNT — NUMBER(7)
  • RDATE — DATE
  • EMPLOYEENO — NUMBER(5) — Foreign key → EMPLOYEE.EMPLOYEENO — NOT NULL
  • CATENO — NUMBER(10) — Foreign key → CATE.CATENO — NOT NULL