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