서울도서관
테이블 (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