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