시스템분석론

테이블 (20)

ACTIVITY (Untitled12)

  • ACTIVITY ID (Key) — 기본 키 — NOT NULL
  • ACTIVITY NAME (Field)
  • DISCRIPTION (Field3)

CASTING (Untitled16)

  • MOVIELD (Key) — int(10) — 외래 키 → MOVIE.MOVIELD — NOT NULL
  • PERSONLD (Key2) — 외래 키 → PERSON.PERSONLD — NOT NULL
  • ROLELD (Key3) — 외래 키 → ROLE.ROLELD — NOT NULL
  • ROLELD (Key4) — 외래 키 → ROLE.ROLELD — NOT NULL

CLASS INFORMATION (Untitled5)

  • CLASS ID (Key) — 기본 키 — NOT NULL
  • MEMBER LIMIT (Field)
  • DIFFICUTLY LEVEL (Field3)
  • TIME (Field4)
  • LEVEL (Field5)
  • PRICE (Field6)

CLIENT (Untitled17)

  • CLIENRLD (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • PHONE (Field2)
  • EMAIL (Field3)
  • ROLELD (Key2) — 외래 키 → ROLE.ROLELD — NOT NULL

COMMUNITY SERVICE ORGANIZATION (Untitled11)

  • COMMUNITY SERVICE ORGANIZATION (Key) — 기본 키 — NOT NULL
  • SERVICE PROVIDER (Key2) — 외래 키 → SERVICE PROVIDER.SERVICE PROVIDER ID — NOT NULL
  • FEMALE CUSTOMERR (Key3) — 외래 키 → FEMALE CUSTOMER.FEMALE CUSTOMERR — NOT NULL
  • FEMALE CUSTOMER'S FAMILY (Key4) — 외래 키 → FEMALE CUSTOMER'S FAMILY.FEMALE CUSTOMER'S FAMILY — NOT NULL
  • SERVICE (Key22) — 외래 키 → SERVICE PROVIDER.SERVICE — NOT NULL

DVDITEM (Untitled15)

  • itemld (Key) — 기본 키 — NOT NULL
  • buyingdate (Field)
  • price (Field2)
  • statusleve (Field3)
  • MOVIELD (Key2) — int(10) — 외래 키 → MOVIE.MOVIELD — NOT NULL

ENROLL (Untitled6)

  • Key — 기본 키 — NOT NULL

FEMALE CUSTOMER (Untitled7)

  • FEMALE CUSTOMERR (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • PHONE NUMBER (Field2)
  • ADDRESS (Field3)
  • ID NUMBER (Field4)
  • SERVICE (Key2) — 외래 키 → SERVICE.SERVICE — NOT NULL

FEMALE CUSTOMER'S FAMILY (Untitled8)

  • FEMALE CUSTOMER'S FAMILY (Key) — 기본 키 — NOT NULL
  • FEMALE CUSTOMERR (Key2) — 외래 키 → FEMALE CUSTOMER.FEMALE CUSTOMERR — NOT NULL
  • NAME (Field)
  • AGE (Field2)
  • ID NUMBER (Field3)

GENRE (Untitled14)

  • GENRELD (Key) — int(5) — 기본 키 — NOT NULL
  • NAME (Field) — char(30)
  • DESCRIPTION (Field2) — LONGTEXT

LECTURER (Untitled)

  • lecture id (Key) — 기본 키 — NOT NULL
  • ACTIVITY ID (Key2) — 외래 키 → ACTIVITY.ACTIVITY ID — NOT NULL
  • name (Field)
  • phonenumber (Field2)
  • address (Field3)
  • grade (Field4)
  • discription (Field5)

MEMBER (Untitled4)

  • MEMBER ID (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • ADDRESS (Field2)
  • AGE (Field3)

MOVIE (Untitled3)

  • MOVIELD (Key) — int(10) — 기본 키 — NOT NULL
  • TITLE (Field) — char(30)
  • PUBYEAE (Field2) — int(4)
  • PUBMONTH (Field3) — int(2)
  • DESCRIPTION (Field4)
  • AWARD (Field5)

MOVIE GENRE (Untitled13)

  • MOVIELD (Key) — int(10) — 외래 키 → MOVIE.MOVIELD — NOT NULL
  • GENRELD (Key2) — int(5) — 외래 키 → GENRE.GENRELD — NOT NULL

PERSON (Untitled18)

  • PERSONLD (Key) — 기본 키 — NOT NULL
  • FNAME (Field)
  • MINITT (Field2)
  • LNAME (Field3)
  • DESCRIPTION (Field4)
  • AWARD (Field5)

RENT (Untitled20)

  • RENTLD (Key) — 기본 키 — NOT NULL
  • itemld (Key2) — 외래 키 → DVDITEM.itemld — NOT NULL

ROLE (Untitled19)

  • ROLELD (Key) — 기본 키 — NOT NULL
  • ROLETITLE (Field)
  • DESCRIPTION (Field2)

SERVICE (Untitled10)

  • SERVICE (Key) — 기본 키 — NOT NULL
  • SERVICE NUMBER (Field)
  • EXPLANATION (Field2)
  • DATA OF SERVICE (Field3)
  • SERVICE TYPE (Field4)

SERVICE PROVIDER (Untitled9)

  • SERVICE PROVIDER ID (Key) — int — 기본 키 — NOT NULL
  • SERVICE (Key2) — 외래 키 → SERVICE.SERVICE — NOT NULL
  • NAME (Field)
  • ADDRESS (Field2)
  • PHONE NUMBER (Field3)
  • UNIQUE NUMBER (Field4)
  • TYPE (Field5)

Untitled2

  • Key — 기본 키 — NOT NULL