Taling

Tables (5)

class (Untitled3)

  • class_no (Field) — Primary key
  • user_no (Key) — Foreign key → user.user_no — NOT NULL
  • class_title (Field2)
  • class_price (Field3)
  • class_day (Field4)
  • class_area (Field5)
  • class_content (Field6)
  • class_pic (Field7)
  • class_period (Field8)
  • post_date (Field9)

class Q&A (Untitled2)

  • user_no (Key) — Foreign key → user.user_no — NOT NULL
  • Q&A_no (Field)
  • Q&A_title (Field2)
  • Q&A_content (Field3)
  • post_date (Field4)

reply (Untitled)

  • reply_no (Key2) — Primary key — NOT NULL
  • class_no (Field3) — Foreign key → class.class_no
  • user_no (Key) — Foreign key → class.user_no — NOT NULL
  • post_date (Field2)

subscribe (Untitled4)

  • subscribe_no (Field) — Primary key
  • user_no (Key) — Foreign key → user.user_no — NOT NULL
  • class_no (Field4) — Foreign key → class.class_no

user (CopyOfUntitled)

  • user_no (Key) — Primary key — NOT NULL
  • id (Field)
  • pw (Field2)
  • phone (Field3)
  • email (Field4)
  • nick (Field5)
  • join_date (Field6)
  • auth (Field7)