ERD 예제 1
테이블 (15)
CLASS (Untitled13)
- cno (Key) — CHAR(30) — 기본 키 — NOT NULL
- code (Field) — CHAR(30)
- time (Field2) — CHAR(30)
- numberofPerson (Field3) — CHAR(30)
- info (Field4) — CHAR(30)
- level (Field5) — CHAR(8)
- mname (Key2) — CHAR(30) — 외래 키 → MEMBER.mname — NOT NULL
- lname (Key3) — CHAR(30) — 외래 키 → LEISURE.lname — NOT NULL
COMPANY (Untitled11)
- cno (Key) — CHAR(30) — 기본 키 — NOT NULL
- cname (Field) — CHAR(50)
- Field2
DEPARTMENT (Untitled)
- dno (Key) — CHAR(8) — 기본 키 — NOT NULL
- dname (Field) — CHAR(32)
- mngStartDate (Field2) — date
- mgrssn (Key2) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
DEPARTMENT_LOCATION (Untitled6)
- dno (Key) — CHAR(8) — 외래 키 → DEPARTMENT.dno — NOT NULL
- lno (Key2) — CHAR(8) — 외래 키 → LOCATION.lno — NOT NULL
DEPENDENT (Untitled7)
- dssn (Key) — CHAR(10) — 기본 키 — NOT NULL
- dname (Field) — CHAR(30)
- gender (Field2) — CHAR(10)
- bdate (Field3) — date
- relation (Field4) — CHAR(50)
- ssn (Key2) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled2)
- ssn (Key) — CHAR(30) — 기본 키 — NOT NULL
- fname (Field) — CHAR(30)
- minit (Field2) — CHAR(4)
- lname (Field3) — CHAR(30)
- bdate (Field4) — date
- address (Field5) — CHAR(40)
- gender (Field6) — CHAR(10)
- salary (Field7) — int(20)
- dno (Key2) — CHAR(8) — 외래 키 → DEPARTMENT.dno — NOT NULL
- superssn (Key3) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
LEISURE (Untitled12)
- lname (Key) — CHAR(30) — 기본 키 — NOT NULL
- exp (Field) — CHAR(50)
- cno (Key2) — CHAR(30) — 외래 키 → CLASS.cno — NOT NULL
LEVEL (Untitled15)
- cno (Key) — CHAR(30) — 외래 키 → CLASS.cno — NOT NULL
- mname (Key2) — CHAR(30) — 외래 키 → MEMBER.mname — NOT NULL
- Field
LOCATION (Untitled5)
- lno (Key) — CHAR(8) — 기본 키 — NOT NULL
- lname (Field) — CHAR(30)
- phone (Field2) — CHAR(20)
MEMBER (Untitled14)
- mname (Key) — CHAR(30) — 기본 키 — NOT NULL
- address (Field) — CHAR(50)
- age (Field2) — CHAR(2)
- level (Field3) — CHAR(8)
PART (Untitled9)
- partNo (Key) — CHAR(30) — 기본 키 — NOT NULL
- exp (Field) — CHAR(50)
- pno (Key2) — CHAR(30) — 외래 키 → PRODUCT.pno — NOT NULL
- ssn (Key3) — CHAR(30) — 외래 키 → PRODUCER.ssn — NOT NULL
PRODUCER (Untitled10)
- ssn (Key) — CHAR(30) — 기본 키 — NOT NULL
- fname (Field) — CHAR(30)
- address (Field2) — CHAR(60)
- pNumber (Field3) — CHAR(20)
- Field4
- cno (Key2) — CHAR(30) — 외래 키 → COMPANY.cno — NOT NULL
PRODUCT (Untitled8)
- pno (Key) — CHAR(30) — 기본 키 — NOT NULL
- exp (Field) — CHAR(50)
- price (Field2) — INT(30)
- cno (Key2) — CHAR(30) — 외래 키 → COMPANY.cno — NOT NULL
PROJECT (Untitled3)
- pno (Key) — CHAR(8) — 기본 키 — NOT NULL
- pname (Field) — CHAR(30)
- dno (Key2) — CHAR(8) — 외래 키 → DEPARTMENT.dno — NOT NULL
WORKSON (Untitled4)
- ssn (Key) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- pno (Key2) — CHAR(8) — 외래 키 → PROJECT.pno — NOT NULL
- hour (Field) — int(3)