시스템 분석론

테이블 (28)

BUY (Untitled16)

  • buyID (Key) — char(10) — 기본 키 — NOT NULL
  • method (Field) — char(4)
  • date (Field2) — date
  • customrtID (Field3) — char(20)
  • empID (Field4) — char(5)
  • customer (Key2) — char(20) — 외래 키 → CUSTOMER.customer — NOT NULL
  • empID (Key3) — char(5) — 외래 키 → EMPLOYEE.empID — NOT NULL

CASTING (Untitled8)

  • movieid (Key) — int(20) — 기본 키 — NOT NULL
  • roleid (Key3) — int(3) — 외래 키 → ROLE.roleid — NOT NULL
  • personid (Kemovieid) — char(30) — 외래 키 → Untitled6.Key — NOT NULL
  • roleid (Key2) — int(3) — 외래 키 → PERSON.personid — NOT NULL
  • description (Field3) — text

COLOR (Untitled19)

  • colorID (Key) — char(5) — 기본 키 — NOT NULL
  • color (Field) — char(30)
  • RGB (Field2) — char(9)
  • description (Field3) — text

CUSTOMER (Untitled15)

  • customer (Key) — char(20) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • phone (Field2) — char(14)
  • vip (Field3) — char(1)

DVDITEM (Untitled6)

  • itemid (Key) — int(100) — 기본 키 — NOT NULL
  • buyingdate (Field) — date
  • price (Field2) — int(30)
  • type (Field3) — int(20)
  • Field4

EMPLOYEE (Untitled17)

  • empID (Key) — char(5) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • phone (Field2) — chsr(14)

GOAL (Untitled18)

  • goalID (Key) — chsr(20) — 기본 키 — NOT NULL
  • year (Field) — date
  • month (Field2)
  • qty (Field3) — int
  • description (Field4) — texe
  • empID (Field5)
  • empID (Key2) — char(5) — 외래 키 → EMPLOYEE.empID — NOT NULL

MOVIE GENRE

  • genreid (Key) — int(5) — 외래 키 → Untitled11.genreid — NOT NULL
  • movirid (Kemovieid) — char(30) — 외래 키 → Untitled6.Key — NOT NULL

PERSON (Untitled10)

  • personid (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • minit (Field2) — char(1)
  • iname (Field3) — char(30)
  • description (Field4) — LONGTEXT
  • award (Field5) — text

PRODUCT (Untitled3)

  • Key (3001) — A — 기본 키 — NOT NULL
  • Key (project) — parts — 외래 키 → Untitled3.Key — NOT NULL
  • Field (3002) — B
  • Field (3003) — C
  • Field (3004) — D

RENT (Untitled7)

  • rentid (Key) — int(1000) — 기본 키 — NOT NULL
  • rentDate (Field) — date
  • retumDate (Field2) — date
  • itemid (Field3) — int(100)
  • cliemtid (Field4)
  • itemid (Key2) — int(100) — 외래 키 → DVDITEM.itemid — NOT NULL

ROLE (Untitled9)

  • roleid (Key) — int(3) — 기본 키 — NOT NULL
  • roletitle (Field) — char(30)
  • description (Field2) — LONGTEXT

SALE (Untitled14)

  • saleID (Key) — char(100) — 기본 키 — NOT NULL
  • shoesID (Field) — char(10)
  • type (Field2) — int
  • buyID (Field3) — char(10)

SHOES (Untitled13)

  • shoesID (Key) — char(10) — 기본 키 — NOT NULL
  • quantity (Field) — int
  • styleID (Field2) — char(5)
  • sizeID (Field3) — char(5)
  • colorID (Field4) — char(5)
  • supID (Field5) — char(10)
  • supID (Key2) — char(10) — 외래 키 → SUPPLIER.supID — NOT NULL
  • colorID (Key3) — char(5) — 외래 키 → COLOR.colorID — NOT NULL
  • styleID (Key4) — char(5) — 외래 키 → STYLE.styleID — NOT NULL

SIZE (Untitled20)

  • sizeID (Key) — char(5) — 기본 키 — NOT NULL
  • size (Field) — char(20)
  • UKsize (Field2) — text

STYLE (Untitled21)

  • styleID (Key) — char(5) — 기본 키 — NOT NULL
  • style (Field) — char(20)
  • description (Field2) — text

SUPPLIER (Untitled12)

  • supID (Key) — char(10) — 기본 키 — NOT NULL
  • supName (Field) — char(30)
  • phone (Field2) — char(14)
  • email (Field3) — char(30)

Untitled

  • Key (ssn) — char(10) — 기본 키 — NOT NULL
  • Key (projectID) — char(10) — 기본 키 — NOT NULL
  • Key (projectID2) — char(10) — 외래 키 → Untitled2.Key — NOT NULL
  • Field (hours)

Untitled (DEPARTMENT)

  • Key (department) — char(10) — 기본 키 — NOT NULL
  • Field (departmentName) — char(20)
  • Field2 (departmentManager) — int(10)
  • Field3 (manageStartDate)
  • Field4

Untitled11

  • genreid (Key) — int(5) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • description (Field2)

Untitled2

  • Key (ssn) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field2 (phone) — char(13)
  • Field
  • Field (address) — char(50)
  • Key (department) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled2 (PROJECT)

  • Key (projectID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field2 (desaription) — text
  • Field

Untitled3 (PRODUCER)

  • Key (project) — parts — 기본 키 — NOT NULL
  • Field (phone) — char(10)
  • Field (name) — char(20)
  • Field (address)

Untitled3 (COMPANY)

  • Key (project) — char — 기본 키 — NOT NULL
  • Key (project2) — parts — 외래 키 → Untitled3.Key — NOT NULL
  • Field (number) — 1
  • Field (price)

Untitled6 (MOVIE)

  • Key (Kemovieid) — char(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (pubYear) — int(4)
  • Field (Month) — int(2)
  • Field (descripition) — LONGTEXT
  • Field (award) — LONGTEXT

Untitled6 (CLIENT)

  • Key (clientid) — char — 기본 키 — NOT NULL
  • Field (name) — char
  • Field (address) — char
  • Field (phone) — char
  • Field (email) — char
  • Field
  • rentid (Key) — int(1000) — 외래 키 → RENT.rentid — NOT NULL

class (Untitled4)

  • classid (Key) — char(10) — 기본 키 — NOT NULL
  • classname (Field) — char(20)
  • time (Field2) — char(30)
  • price (Field3) — char(40)
  • level (Field4) — char(10)

memeber (Untitled5)

  • memberid (Key2) — char(15) — 기본 키 — NOT NULL
  • name (Key) — char(10) — 기본 키 — NOT NULL
  • address (Field) — char(30)
  • phone (Field2) — char(30)
  • birthdate (Field3) — char(10)