b7
Tables (7)
Untitled (b7_LECTURE)
- Key (lecture_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → b7_member.Key — NOT NULL
- Field (lecture_name) — VARCHAR2(100)
- Field (lecture_date) — DATE
- Field (lecture_price) — NUMBER
- Field (lecture_info) — VARCHAR2(10000)
- Field2
Untitled (b7_ORDER)
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (b7_CART)
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (b7_REPLE)
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (b7_LECTUREIMAGE)
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (b7_mailAuth)
- Key (member_no) — NUMBER — Foreign key → b7_member.Key — NOT NULL
b7_member (b7_MEMBER)
- Key (member_no) — NUMBER — Primary key — NOT NULL
- Field (member_id) — VARCHAR2(100)
- Field (member_pw) — VARCHAR2(1000)
- Field (member_nick) — VARCHAR2(100)
- Field (member_email) — VARCHAR2(1000)
- Field (member_birth) — DATE
- Field (member_joinDate) — DATE
- Field (member_phone) — VARCHAR2(100)