과제

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