시스템분석론
테이블 (32)
ACTIVITY (Untitled20)
- activityld (Key) — char(10) — 기본 키 — NOT NULL
- activityName (Field) — char(30)
- description (Field2) — longtext
BUY (Untitled10)
- buyID (Key) — char(10) — 기본 키 — NOT NULL
- method (Field) — char(4)
- date (Field2) — date
- customerID (Key2) — char(20) — 외래 키 → CUSTOMER.customerID — NOT NULL
- empID (Key3) — char(5) — 외래 키 → EMPLOYEE.empID — NOT NULL
CASTING (Untitled5)
- movieid (Key) — int(10) — 외래 키 → DVD MOVIE.movieid — NOT NULL
- personld (Key2) — int(10) — 외래 키 → PERSON.personld — NOT NULL
- roleld (Key3) — int(3) — 외래 키 → ROLE.roleld — NOT NULL
- description (Field) — text
CLASS (Untitled21)
- classld (Key) — char(30) — 기본 키 — NOT NULL
- className (Field) — char(30)
- lecturer (Field2) — char(30)
- time (Field3) — char(30)
- price (Field4) — int
- level (Field5) — char(10)
- activityld (Key2) — char(10) — 외래 키 → ACTIVITY.activityld — NOT NULL
- lectureld (Key3) — char(10) — 외래 키 → LECTURER.lectureld — NOT NULL
CLIENT (Untitled7)
- clientld (Key) — int(100) — 기본 키 — NOT NULL
- name (Field) — char(30)
- phone (Field2) — int(11)
- email (Field3) — char(30)
- address (Field4) — char(30)
CLIENT (Untitled25)
- clientld (Key) — int(5) — 기본 키 — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(100)
- phone (Field3) — int(11)
- email (Field4) — char(100)
- ssn (Field5) — char(13)
COLOR (Untitled16)
- colorID (Key) — char(5) — 기본 키 — NOT NULL
- color (Field) — char(30)
- RGB (Field2) — char(9)
- description (Field3) — text
CUSTOMER (Untitled11)
- customerID (Key) — char(20) — 기본 키 — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(14)
- VIP (Field3) — char(1)
DEPENDANT (Untitled28)
- dependantld (Key) — int(5) — 기본 키 — NOT NULL
- name (Field) — char(10)
- phone (Field2) — int(11)
- clientld (Key2) — int(5) — 외래 키 → CLIENT.clientld — NOT NULL
- ssn (Field3) — char(13)
DVD MOVIE (Untitled)
- movieid (Key) — int(10) — 기본 키 — NOT NULL
- title (Field) — char(30)
- pubYear (Field2) — int(4)
- pubMonth (Field3) — int(2)
- description — LONGTEXT
- award (Field4) — LONGTEXT
DVDITEM (Untitled2)
- itemld (Key) — int(100) — 기본 키 — NOT NULL
- buyingdate (Field) — date
- price (Field2) — int(10)
- statustevel (Field3) — char(1)
- movieid (Key2) — int(10) — 외래 키 → DVD MOVIE.movieid — NOT NULL
EMPLOYEE (Untitled18)
- empID (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char((30))
- phone (Field2) — char(14)
ENROLL (Untitled26)
- sereID (Key) — integer — 기본 키 — NOT NULL
- grade (Field) — char(2)
- review (Field2) — LONGTEXT
- clientld (Key2) — int(5) — 외래 키 → CLIENT.clientld — NOT NULL
- serviceld (Key3) — int(1000) — 외래 키 → SERVICE.serviceld — NOT NULL
ENROLL (Untitled22)
- memberld (Key) — char(10) — 외래 키 → MEMBER.memberld — NOT NULL
- classld (Key2) — char(30) — 외래 키 → CLASS.classld — NOT NULL
- paymentYN (Field) — char(3)
GENRE (Untitled4)
- genreld (Key) — int(5) — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — LONGTEXT
GOAL (Untitled17)
- goallD (Key) — char(10) — 기본 키 — NOT NULL
- year (Field) — date
- month (Field2) — date
- qty (Field3) — int
- description (Field4) — text
- empID (Key2) — char(5) — 외래 키 → EMPLOYEE.empID — NOT NULL
LECTURER (Untitled24)
- lectureld (Key) — char(10) — 기본 키 — NOT NULL
- name (Field)
- phone (Field2) — d
- address (Field3)
- grade (Field4)
- desciption (Field5)
MANAGER (Untitled31)
- managerld (Key) — int(100) — 기본 키 — NOT NULL
- name (Field) — char(20)
- phone (Field2) — char(20)
- email (Field3) — char(30)
- description (Field4) — text
MEMBER (Untitled23)
- memberld (Key) — char(10) — 기본 키 — NOT NULL
- memberName (Field) — char(30)
- address (Field2) — char(30)
- phone (Field3) — char(15)
- email (Field4) — char(20)
- birthDate (Field5) — date
MOVIE_GENRE (Untitled3)
- movieid (Key) — int(10) — 외래 키 → DVD MOVIE.movieid — NOT NULL
- genreld (Key2) — int(5) — 외래 키 → GENRE.genreld — NOT NULL
NOTE (Untitled32)
- noteld (Key) — 기본 키 — NOT NULL
- serviceld (Key2) — int(1000) — 외래 키 → SERVICE.serviceld — NOT NULL
- description (Field) — text
PERSON (Untitled8)
- personld (Key) — int(10) — 기본 키 — NOT NULL
- fname (Field) — char(30)
- minit (Field2) — char(1)
- lname (Field3) — char(30)
- description (Field4) — LONGTEXT
- award (Field5) — text
RENT (Untitled6)
- rentld (Key) — int(100) — 기본 키 — NOT NULL
- rentDate (Field) — date
- returnDate (Field2) — date
- clientld (Key2) — int(100) — 외래 키 → CLIENT.clientld — NOT NULL
- itemld (Key3) — int(100) — 외래 키 → DVDITEM.itemld — NOT NULL
ROLE (Untitled9)
- roleld (Key) — int(3) — 기본 키 — NOT NULL
- roletitle (Field) — char(30)
- description (Field2) — LONGTEXT
SALE (Untitled12)
- saleID (Key) — char(100) — 기본 키 — NOT NULL
- shoesID (Key2) — char(10) — 외래 키 → SHOES.shoesID — NOT NULL
- qty (Field) — int
- buyID (Key3) — char(10) — 외래 키 → BUY.buyID — NOT NULL
SERVICE (Untitled27)
- serviceld (Key) — int(1000) — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- year (Field3) — int(4)
- month (Field4) — int(2)
- fee (Field5) — integer
- providerld (Key2) — int(100) — 외래 키 → SERVICEPROVIDER.providerld — NOT NULL
- subjectld (Key3) — int(10) — 외래 키 → SUBJECT.subjectld — NOT NULL
- managerld (Key4) — int(100) — 외래 키 → MANAGER.managerld — NOT NULL
SERVICEPROVIDER (Untitled29)
- providerld (Key) — int(100) — 기본 키 — NOT NULL
- name (Field) — char(100)
- address (Field2) — char(100)
- phone (Field3) — int(12)
- grade (Field4) — float(3)
- memo (Field5) — LONGTEXT
- type (Field6) — char(4)
SHOES (Untitled13)
- shoesID (Key) — char(10) — 기본 키 — NOT NULL
- quantity (Field) — int
- styleID (Key3) — char(5) — 외래 키 → STYLE.styleID — NOT NULL
- sizeID (Key2) — char(5) — 외래 키 → SIZE.sizeID — NOT NULL
- colorID (Key4) — char(5) — 외래 키 → COLOR.colorID — NOT NULL
- supID (Key5) — char(10) — 외래 키 → SUPPLIER.supID — NOT NULL
SIZE (Untitled15)
- sizeID (Key) — char(5) — 기본 키 — NOT NULL
- size (Field) — float
- Field2 — float
STYLE (Untitled14)
- styleID (Key) — char(5) — 기본 키 — NOT NULL
- style (Field) — char(2)
- description (Field2) — text
SUBJECT (Untitled30)
- subjectld (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- memo (Field2) — LONGTEXT
SUPPLIER (Untitled19)
- supID (Key) — char(10) — 기본 키 — NOT NULL
- supName (Field) — char(30)
- phone (Field2) — char(14)
- email (Field3) — char(30)