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