기말과제

테이블 (4)

Book (Untitled5)

  • ISBN (Key) — char(13) — 기본 키 — NOT NULL
  • FieldCode (Field) — char(20)
  • RentalNumber (Field2) — int(9)
  • BookTitle (Field3) — char(70)
  • IssuedYear (Field4) — int(4)
  • Language (Field5) — char(20)
  • IssuedNation (Field6) — char(30)
  • MemberId (Key2) — char(10) — 외래 키 → Member.MemberId — NOT NULL

Member (Untitled3)

  • MemberId (Key) — char(10) — 기본 키 — NOT NULL
  • MemberAge (Field) — int(2)
  • MemberGender (Field2) — char(5)
  • BookRentalNumber (Field3) — int(10)
  • ISBN (Key2) — char(13) — 외래 키 → Book.ISBN — NOT NULL
  • ProgramId (Key3) — char(10) — 외래 키 → Program.ProgramId — NOT NULL
  • MemberName (Field4) — char(10)
  • BirthDay (Field5) — int(8)
  • PhoneNumber (Field6) — int(11)
  • Address (Field7) — char(70)

Program (Untitled)

  • ProgramId (Key) — char(10) — 기본 키 — NOT NULL
  • LimitNumber (Field2) — int(3)
  • RegisteredMember (Field3) — int(3)
  • ApplyMember (Field4) — int(3)
  • FieldCode (Field6) — char(20)
  • LimitAge (Field) — int(2)
  • SubcontractorId (Key2) — char(10) — 외래 키 → Subcontractor.SubcontractorId — NOT NULL
  • MemberId (Key3) — char(10) — 외래 키 → Member.MemberId — NOT NULL
  • ProgramTitle (Field5) — char(50)

Subcontractor (Untitled2)

  • SubcontractorId (Key) — char(10) — 기본 키 — NOT NULL
  • ProgramId (Key2) — char(10) — 외래 키 → Program.ProgramId — NOT NULL
  • SubcontractorName (Field) — char(20)
  • Address (Field2) — char(70)