webtoon

Tables (13)

AT_DS (Untitled9)

  • Aname (Key) — char(10) — Foreign key → AUTHOR.Aname — NOT NULL
  • Dcode (Key2) — integer — Foreign key → DRAWING_STYLE.Dcode — NOT NULL

AUTHOR (Untitled2)

  • Aname (Key) — char(10) — Primary key — NOT NULL
  • sex (Field) — char(1)
  • age (Field2) — integer

DRAWING_STYLE (Untitled5)

  • Dcode (Key) — integer — Primary key — NOT NULL
  • Dtype (Field) — char(30)

MATERIAL (Untitled4)

  • Mcode (Key) — integer — Primary key — NOT NULL
  • Mtype (Field) — char(30)

RD_AT (Untitled10)

  • userID (Key) — char(20) — Foreign key → READER.userID — NOT NULL
  • Aname (Key2) — char(10) — Foreign key → AUTHOR.Aname — NOT NULL

RD_DS (Untitled13)

  • userID (Key) — char(20) — Foreign key → READER.userID — NOT NULL
  • Dcode (Key2) — integer — Foreign key → DRAWING_STYLE.Dcode — NOT NULL

RD_MT (Untitled12)

  • userID (Key) — char(20) — Foreign key → READER.userID — NOT NULL
  • Mcode (Key2) — integer — Foreign key → MATERIAL.Mcode — NOT NULL

RD_WT (Untitled11)

  • userID (Key) — char(20) — Foreign key → READER.userID — NOT NULL
  • Wcode (Key2) — integer — Foreign key → WEBTOON.Wcode — NOT NULL

READER (Untitled3)

  • userID (Key) — char(20) — Primary key — NOT NULL
  • sex (Field) — char(1)
  • age (Field2) — integer

WEBTOON (Untitled)

  • Wcode (Key) — integer — Primary key — NOT NULL
  • Wname (Field) — char(30)
  • preferred_sex (Field2) — char(1)
  • prferred_age (Field3) — integer
  • continuing (Field4) — char(3)
  • drama (Field5) — char(1)
  • plot (Field6) — char(200)

WT_AT (Untitled6)

  • Wcode (Key) — integer — Foreign key → WEBTOON.Wcode — NOT NULL
  • Aname (Key2) — char(10) — Foreign key → AUTHOR.Aname — NOT NULL

WT_DS (Untitled8)

  • Wcode (Key) — integer — Foreign key → WEBTOON.Wcode — NOT NULL
  • Dcode (Key2) — integer — Foreign key → DRAWING_STYLE.Dcode — NOT NULL

WT_M (Untitled7)

  • Wcode (Key) — integer — Foreign key → WEBTOON.Wcode — NOT NULL
  • Mcode (Key2) — integer — Foreign key → MATERIAL.Mcode — NOT NULL