ex7
Tables (5)
ABC (Untitled)
- PMno. (Key) — char(16) — Primary key — NOT NULL
- PMname (Field) — char(4)
- PMbirthday (Field2) — char(6)
- Field3 — char(16)
Bank (Untitled5)
- loan (Key) — char(100) — Primary key — NOT NULL
- amount (Field) — char(100)
- loanno. (Field2) — char(16)
- PMno. (Key2) — char(16) — Foreign key → ABC.PMno. — NOT NULL
PM (Untitled4)
- PMno. (Key) — char(16) — Primary key — NOT NULL
- PMname (Field) — char(4)
- PMbirthday (Field2) — char(6)
project (Untitled2)
- pjno. (Key) — char(16) — Primary key — NOT NULL
- PMno. (Field) — char(16)
- loan (Field2) — char(100)
- subconno. (Field3) — char(16)
- loan (Key2) — char(100) — Foreign key → Bank.loan — NOT NULL
- PMno. (Key3) — char(16) — Foreign key → PM.PMno. — NOT NULL
- subconno. (Key4) — char(16) — Foreign key → subcon..subconno. — NOT NULL
subcon. (Untitled3)
- subconno. (Key) — char(16) — Primary key — NOT NULL
- field (Field) — char(20)
- affinity (Field2)