DEMO01_ERD
Tables (6)
ADMIN
- ID — VARCHAR2(30) — Foreign key → MEMBER.ID — NOT NULL
- UPDATE_DATE — DATE
COURSE
- CNO — NUMBER(10) — Primary key — NOT NULL
- NAME — VARCHAR2(30)
- SUBJECT — VARCHAR2(30)
COURSE_HISTORY
- HNO — NUMBER(10) — Primary key — NOT NULL
- ID — VARCHAR2(30) — Foreign key → MEMBER.ID — NOT NULL
- CNO — NUMBER(10) — Foreign key → COURSE.CNO — NOT NULL
MEMBER
- ID — VARCHAR2(30) — Primary key — NOT NULL
- Field (NAME) — VARCHAR2(30)
- REGDATE — DATE
REPLY
- RNO — NUMBER(10) — Primary key — NOT NULL
- TITLET (TITLE) — VARCHAR2(200)
- CONTENT — VARCHAR2(500
- ID — VARCHAR2(30) — Foreign key → MEMBER.ID — NOT NULL
- TNO — NUMBER(10) — Foreign key → TOPIC.TNO — NOT NULL
TOPIC
- TNO — NUMBER(10) — Primary key — NOT NULL
- TITLE — VARCHAR(200)
- CONTENT — VARCHAR2(1000)
- ID — VARCHAR2(30) — Foreign key → MEMBER.ID — NOT NULL