ㄱㅁㄳ

Tables (12)

AUTHOR

  • authID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • alternativeName (Field2) — char(30)
  • description (Field3) — text
  • email (Field4) — char(30)
  • majorWorks (Field5) — text

BOOK

  • ISBN — char(13) — Primary key — NOT NULL
  • title (Field) — char(50)
  • pubDate (Field2) — date
  • type (Field3) — char(10)
  • kdc(6th) (Field4) — char(eo)
  • price (Field5) — integer
  • workID — int(20) — Foreign key → WORK.workID — NOT NULL
  • pubID (Key) — int(10) — Foreign key → PUBLISHER.pubID — NOT NULL

EVENT (Untitled6)

  • eventID (Key) — int(20) — Primary key — NOT NULL
  • evertName (Field) — char(20)
  • description (Field2) — text

ITEM (Untitled10)

  • itemEM (Key) — char(30) — Primary key — NOT NULL
  • callNum (Field) — char(30)
  • purchasedDate (Field2) — date
  • price (Field3) — int(20)
  • ISBN — char(13) — Foreign key → BOOK.ISBN — NOT NULL

PERSON (Untitled5)

  • oersonID (Key) — int(20) — Primary key — NOT NULL
  • perName (Field) — char(30)
  • description (Field2) — text

PUBLISHER (Untitled9)

  • pubID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • address (Field2) — dhar(50)
  • phone (Field3) — char(20)
  • fax (Field4) — char(20)
  • email (Field5) — char(30)

SUBJECT

  • subID (Key) — int(20) — Primary key — NOT NULL
  • subjectHeading (Field) — char(30)
  • description (Field2) — text

WORK

  • workID — int(20) — Primary key — NOT NULL
  • Field (workTitle) — char(60)

WORK_AUTHOR

  • workID — int(20) — Foreign key → WORK.workID — NOT NULL
  • authID (Key) — int(10) — Foreign key → AUTHOR.authID — NOT NULL
  • role (Field) — char(20)

WORK_EVENT (Untitled7)

  • workID — int(20) — Foreign key → WORK.workID — NOT NULL
  • eventID (Key) — int(20) — Foreign key → EVENT.eventID — NOT NULL

WORK_PERSON

  • workID — int(20) — Foreign key → WORK.workID — NOT NULL
  • oersonID (Key) — int(20) — Foreign key → PERSON.oersonID — NOT NULL

WOR_SUBJECT (WOR-SUBJECT)

  • workID — int(20) — Foreign key → WORK.workID — NOT NULL
  • subID (Key) — int(20) — Foreign key → SUBJECT.subID — NOT NULL