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