b7_teacher_v.1.
Tables (10)
Untitled (b7_LECTURE)
- Key (lecture_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → b7_member.Key — NOT NULL
- Key (teacher_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (lecture_name) — VARCHAR2(100)
- Field (lecture_date) — DATE
- Field (lecture_price) — NUMBER
- Field (lecture_info) — VARCHAR2(10000)
- Field2 (lecture_count) — NUMBER
Untitled (b7_ORDER)
- Key (order_no) — NUMBER — Primary key — NOT NULL
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (teacher_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (order_date) — DATE
- Field (order_refund) — VARCHAR2(1)
Untitled (b7_CART)
- Key (cart_no) — NUMBER — Primary key — NOT NULL
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (teacher_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (b7_REPLY)
- Key (reple_no) — NUMBER — Primary key — NOT NULL
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (teacher_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (reple_text) — VARCHAR2(100)
- Field (reple_date) — DATE
Untitled (b7_LECTUREIMAGE)
- Key (lectureimage_no) — NUMBER — Primary key — NOT NULL
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (teacher_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — VARCHAR2(1000)
- Field (image_originalName) — VARCHAR2(1000)
Untitled (b7_mailAuth)
- Key (mailAuth_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → b7_member.Key — NOT NULL
- Field (mailAuth_key) — NUMBER
- Field (mailAuth_state) — VARCHAR2(1)
- Field (mailAuth_date) — DATE
Untitled (관리자)
- Key — Primary key — NOT NULL
Untitled (b7_TEACHER)
- Key (teacher_no) — NUMBER — Primary key — NOT NULL
- Field (teacher_id) — VARCHAR2(100)
- Field2 (teacher_pw) — VARCHAR2(1000)
- Field3
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)
lecture_like (b7_LECTURE_LIKE)
- Key (lecture_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL