webnovel

Tables (6)

Member (유저)

  • memberId (Key) — Primary key — NOT NULL
  • PreferNovel (Field)
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6

Novel (소설)

  • Novelid (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

PreferNovel (선호소설)

  • id (Key) — Primary key — NOT NULL
  • memberId (Key2) — Foreign key → Member.memberId — NOT NULL
  • Novelid (Key3) — Foreign key → Novel.Novelid — NOT NULL
  • preferDate (Field)

PurchaseEpisode (구매한 에피소드)

  • purchaseId (Key) — Primary key — NOT NULL
  • memberId (Key2) — Foreign key → Member.memberId — NOT NULL
  • purchseDate (Field3)

episode (에피소드)

  • EpisodeID (Key) — Primary key — NOT NULL
  • purchaseId (Key2) — Foreign key → PurchaseEpisode.purchaseId — NOT NULL
  • memberId (Key22) — Foreign key → PurchaseEpisode.memberId — NOT NULL
  • Novelid (Key3) — Foreign key → Novel.Novelid — NOT NULL
  • id (Field)

ticket (Untitled)