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)