weekend

Tables (4)

MEMBERROLE (Untitled4)

  • Key (ROLEID) — NUMBER — Primary key — NOT NULL
  • Field (ROLENAME) — VARCHAR2

MEMBERS (Untitled)

  • Key (ID) — VARCAHR2 — Primary key — NOT NULL
  • Key (ROLEID) — NUMBER — Foreign key → MEMBERROLE.Key — NOT NULL
  • Field (PW) — VARCHAR2
  • Field (NAME) — VARCHAR2
  • Field (EMAIL) — VARCHAR2
  • Field (ADDRESS) — VARCHAR2
  • Field (PHONE) — VARCHAR2

TYPES (Untitled3)

  • Key (TYPEID) — NUMBER — Primary key — NOT NULL
  • Field (TYPENAME) — VARCHAR

WRITING (Untitled2)

  • Key (WRITINGID) — NUMBER — Primary key — NOT NULL
  • Key (ID) — VARCAHR2 — Foreign key → MEMBERS.Key — NOT NULL
  • Key (TYPEID) — NUMBER — Foreign key → TYPES.Key — NOT NULL
  • Key (ROLEID) — NUMBER — Foreign key → MEMBERS.Key — NOT NULL
  • Field (WIRTINGTITLE) — VARCHAR2
  • Field (WRITINGDATE) — DATE
  • Field (WRITINGVIEW) — NUMBER
  • Field (WRITINGDETAIL) — CLOB