기말과제
테이블 (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