서울도서관

테이블 (9)

DATA (Untitled3)

  • code (Key3) — char(10) — 기본 키 — NOT NULL
  • name (Field6) — char(30)
  • openDate (Field) — date
  • editDate (Field2) — date
  • classification (Field3) — char(20)
  • source (Field4) — char(20)
  • type (Field5) — char(20)
  • projectCode (Key) — char(8) — 외래 키 → PROJECT.code — NOT NULL
  • period (Field7) — date

DEPARTMENT (SEOUL) (Untitled5)

  • code (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • description (Field2) — long text
  • code (Key2) — char(8) — 외래 키 → PROJECT.code — NOT NULL

EMPLOYEE (Untitled7)

  • code (Key) — char(9) — 기본 키 — NOT NULL
  • departmentCode (Key2) — int(10) — 외래 키 → DEPARTMENT (SEOUL).code — NOT NULL
  • name (Field) — char(20)
  • position (Field2) — char(20)
  • phone (Field3) — int
  • workDescription (Field4) — longtext

MANAGER (CopyOfUntitled2)

  • code (Key) — int(13) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • department (Field2) — char(30)
  • phone (Field3) — int
  • email (Field4) — char
  • birthday (Field5) — date
  • address (Field6) — char(50)

PROJECT (Untitled)

  • code (Key) — char(8) — 기본 키 — NOT NULL
  • name (Field3) — char(20)
  • department (Field) — char(30)
  • classification (Field4) — char(20)
  • discription (Field5) — long text
  • buget (Field6) — int
  • period (Field7) — date
  • code (Key2) — int(13) — 외래 키 → MANAGER.code — NOT NULL

REPORT (Untitled6)

  • code (Key2) — char(5) — 기본 키 — NOT NULL
  • projectCode (Key) — char(8) — 외래 키 → PROJECT.code — NOT NULL
  • title (Field) — char(20)
  • manager (Field2) — char(10)
  • date (Field3) — date
  • classification (Field4) — char(30)
  • discription (Field5) — longtext

RESEARCHER (Untitled2)

  • code (Key) — int(13) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • department (Field2) — char(30)
  • phone (Field3) — int
  • email (Field4) — char
  • birthday (Field5) — date
  • address (Field6) — char(50)

processed (Untitled4)

  • researcherCode (Key) — int(13) — 외래 키 → RESEARCHER.code — NOT NULL
  • dataCode (Key3) — char(10) — 외래 키 → DATA.code — NOT NULL

use (Untitled8)

  • reportCode (Key2) — char(5) — 외래 키 → REPORT.code — NOT NULL
  • projectCode (Key) — char(8) — 외래 키 → REPORT.projectCode — NOT NULL
  • dataCode (Key3) — char(10) — 외래 키 → DATA.code — NOT NULL