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)