시스템분석론

테이블 (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)