기말과제
테이블 (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)