기말과제

테이블 (6)

AcademicDB (Untitled2)

  • DBID (Key) — int(20) — 기본 키 — NOT NULL
  • ISSN (Field32) — int(20) — 외래 키 → Journal.ISSN
  • DBName (Field2) — char(30)
  • type (Field) — char(30)
  • URL (Field3) — text

Author (Untitled6)

  • ssn (Field2) — int(20) — 기본 키
  • aName (Field) — char(30)
  • phone (Field3) — text

Journal (Untitled4)

  • ISSN (Field3) — int(20) — 기본 키
  • ssn (Field22) — int(20) — 외래 키 → Author.ssn
  • jName (Field2) — char(30)
  • publisherName (Field) — char(30)

Library (Untitled)

  • libraryID (Field2) — int(20) — 기본 키
  • libraryName (Field) — char(30)
  • libraryAddress (Field3) — text

LicensContract (Untitled3)

  • libraryID (Field22) — int(20) — 외래 키 → Library.libraryID
  • DBID (Key) — int(20) — 외래 키 → AcademicDB.DBID — NOT NULL
  • rate (Field) — int(15)
  • subStart (Field2) — date
  • subFinish (Field3) — date

Paper (Untitled5)

  • ISSN (Field32) — int(20) — 외래 키 → Journal.ISSN
  • pName (Field2) — text
  • publishingYear (Field3) — date