과제
테이블 (21)
Acitivity_On (Untitled4)
- memberID (Key) — int(30) — 외래 키 → Member.memberID — NOT NULL
- serialNumber (Key2) — int(30) — 외래 키 → Class.serialNumber — NOT NULL
Activity (Untitled2)
- activityCode (Key) — int(30) — 기본 키 — NOT NULL
- activityName (Field) — char(30)
- activityExplain (Field2) — text
Class (Untitled)
- serialNumber (Key) — int(30) — 기본 키 — NOT NULL
- activityCode (Key2) — int(30) — 외래 키 → Activity.activityCode — NOT NULL
- operatingHours (Field) — float(10)
- imitedPeople (Field2) — int(20)
- nowEnrollPeople (Field3) — int(20)
- level (Field4) — char(10)
Customer (Untitled5)
- residentNumber (Key) — int(20) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phoneNumber (Field3) — int(20)
DVD (Untitled11)
- Dcode (Key) — int(20) — 기본 키 — NOT NULL
- buydate (Field) — date
- rentnumber (Field2) — int(30)
- Field3
- identifier (Key2) — char(20) — 외래 키 → Movie.identifier — NOT NULL
DependentFamily (Untitled6)
- dResidentNumber (Key) — int(20) — 기본 키 — NOT NULL
- dname (Field) — char(20)
- age (Field2) — int(20)
- residentNumber (Key2) — int(20) — 외래 키 → Customer.residentNumber — NOT NULL
Member (Untitled3)
- memberID (Key) — int(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- age (Field3) — int(10)
Movie (Untitled13)
- identifier (Key) — char(20) — 기본 키 — NOT NULL
- name (Field) — char(30)
- madetime (Field2) — date
- dcode (Key2) — int(30) — 외래 키 → director.dcode — NOT NULL
- acode (Key3) — int(30) — 외래 키 → actor.acode — NOT NULL
Provider (Untitled9)
- prNumber (Key) — int(20) — 기본 키 — NOT NULL
- prName (Field) — char(20)
- prAddress (Field2) — char(30)
- prPhoneNumber (Field3) — int(20)
Service (Untitled7)
- serviceCode (Key) — int(20) — 기본 키 — NOT NULL
- serviceExplain (Field) — text
- prNumber (Key2) — int(20) — 외래 키 → Provider.prNumber — NOT NULL
Service-Customer_Work (Untitled8)
- residentNumber (Key) — int(20) — 외래 키 → Customer.residentNumber — NOT NULL
- serviceCode (Key2) — int(20) — 외래 키 → Service.serviceCode — NOT NULL
- serviceDate (Field) — date
actor (Untitled14)
- acode (Key) — int(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- biography (Field2) — text
customer (Untitled10)
- cNumber (Key) — int(20) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
customer (Untitled18)
- cnumber (Key) — int(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(20)
- phonenumber (Field3) — int(20)
- buytype (Field4) — char(20)
department (Untitled19)
- scode (Key) — int(30) — 외래 키 → shoes.scode — NOT NULL
- pcode (Key2) — int(30) — 외래 키 → provider.pcode — NOT NULL
- stock (Field) — int(20)
director (Untitled15)
- dcode (Key) — int(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- biography (Field2) — text
provider (Untitled17)
- pcode (Key) — int(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
rent-on (Untitled12)
- cNumber (Key) — int(20) — 외래 키 → customer.cNumber — NOT NULL
- Dcode (Key2) — int(20) — 외래 키 → DVD.Dcode — NOT NULL
- rentDate (Field) — date
- rentTime (Field2) — date
shoes (Untitled16)
- scode (Key) — int(30) — 기본 키 — NOT NULL
- style (Field) — char(20)
- size (Field2) — int(20)
- color (Field3) — char(20)
trade (Untitled20)
- cnumber (Key) — int(30) — 외래 키 → customer.cnumber — NOT NULL
- scode (Key2) — int(30) — 외래 키 → department.scode — NOT NULL
- pcode (Key22) — int(30) — 외래 키 → department.pcode — NOT NULL
- tradedate (Field) — date
- trademount (Field2) — int(20)
- mnumber (Key3) — int(20) — 외래 키 → trademan.mnumber — NOT NULL
trademan (Untitled21)
- mnumber (Key) — int(20) — 기본 키 — NOT NULL
- name (Field) — char(20)