kd10_issue
Tables (3)
CATE
- CATENO — NOT NULL — Primary key — NOT NULL
- GRP — NOT NULL — NOT NULL
- NAME — NOT NULL — NOT NULL
- CNT — NOT NULL — NOT NULL
- SEQNO — NOT NULL — NOT NULL
- VISIBLE — NOT NULL — NOT NULL
- RDATE — NOT NULL — NOT NULL
EMPLOYEE
- EMPLOYEENO — NOT NULL — Primary key — NOT NULL
- ID — NOT NULL — NOT NULL
- PASSWORD — NOT NULL — NOT NULL
- MNAME — NOT NULL — NOT NULL
- RDATE — NOT NULL — NOT NULL
- GRADE — NOT NULL — NOT NULL
contents
- contentsno — NOT NULL — Primary key — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- recom — NUMBER(7) — NOT NULL
- cnt — NUMBER(7) — NOT NULL
- replycnt — NUMBER(7) — NOT NULL
- passwd — VARCHAR2(100) — NOT NULL
- word — VARCHAR2(200)
- rdate — DATE — NOT NULL
- file1 — VARCHAR(100)
- file1saved — VARCHAR(100)
- thumb1 — VARCHAR(100)
- size1 — NUMBER(10)
- price — NUMBER(10)
- dc — NUMBER(10)
- saleprice — NUMBER(10)
- point — NUMBER(10)
- salecnt — NUMBER(10)
- map — VARCHAR2(1000)
- youtube — VARCHAR2(1000)
- mp4 — VARCHAR2(100)
- visible — CHAR(1) — NOT NULL
- EMPLOYEENO — NOT NULL — Foreign key → EMPLOYEE.EMPLOYEENO — NOT NULL
- CATENO — NOT NULL — Foreign key → CATE.CATENO — NOT NULL