시스템 분석론
테이블 (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)