DEMO1_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 — VARCHAR(30)
  • SUBJECT — VARCHAR(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
  • NAME — VARCHAR2(30
  • REGDATE — DATE

REPLY

  • RNO — NUMBER(10) — Primary key — NOT NULL
  • TITLE — VARCHAR2(200)
  • CONTENT — VARCHAR2(500
  • TNO — NUMBER(10) — Foreign key → TOPIC.TNO — NOT NULL
  • ID (ID2) — VARCHAR2(30) — Foreign key — NOT NULL
  • ID — VARCHAR2(30) — Foreign key → MEMBER.ID — NOT NULL

TOPIC

  • TNO — NUMBER(10) — Primary key — NOT NULL
  • TITLE — VARCHAR2(200)
  • CONTENT — VARCHAR2(1000)
  • ID — VARCHAR2(30) — Foreign key → MEMBER.ID — NOT NULL