Exe7-006
Tables (5)
Untitled (전문분야)
- Key (전문분야ID) — char(10) — Primary key — NOT NULL
- Field (이름) — char(10)
- Field
Untitled (대출)
- Key (대출ID) — char(10) — Primary key — NOT NULL
- Field (금액)
- Field (대출일)
- Field (상환일)
- Field (수량)
- Field (대출조건) — txt
- Key (proID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (사원ID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Field
Untitled2 (PROJECT)
- Key (proID) — char(10) — Primary key — NOT NULL
- Key (사원ID) — char(10) — Foreign key → Untitled3.Key — NOT NULL
- Field
- Key (하도급ID) — char(10) — Foreign key → Untitled4.Key — NOT NULL
Untitled3 (관리자)
- Key (사원ID) — char(10) — Primary key — NOT NULL
- Field (이름) — char(10)
- Field (전화) — char(11)
- Field
Untitled4 (하도급업자)
- Key (하도급ID) — char(10) — Primary key — NOT NULL
- Field (이름)
- Field (주소)
- Field2 (전화)
- Key (전문분야ID) — char(10) — Foreign key → Untitled.Key — NOT NULL