꼬끼오
테이블 (17)
Copy Of Copy Of Untitled22 (contents_supplier)
- Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (type)
- Key (typeID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
Untitled (contents_member)
- Key (memberID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (member)
- Key (memberID) — int(30) — 기본 키 — NOT NULL
- Field (ssn) — int(13)
- Field (name) — char(30)
- Field (address) — char(50)
- Field (phone) — int(11)
- Field (enrollDate) — date
Untitled (supplier_type)
- Key (supplierID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (typeID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (contents_type)
- Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (typeID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (contents_kdc)
- Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (kdcCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (kdc)
- Key (kdcCode) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
Untitled (contents_genre)
- Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (subjectID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (genre)
- Key (genreID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
Untitled (work)
- Key (workID) — int(30) — 기본 키 — NOT NULL
- Field (title) — char(50)
Untitled (person)
- Key (personID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (role) — char(20)
- Field (gender) — char(10)
- Field (nationality) — char(30)
Untitled (contents_person)
- Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (personID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (work_author)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (authorID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (supplier)
- Key (supplierID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (department) — char(10)
- Field (depPhone) — int(11)
- Field (grade) — int(3)
Untitled (author)
- Key (authorID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (alternativeName) — char(30)
- Field (nationality) — char(30)
Untitled (contents)
- Key (ID) — char(30) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (episode) — int(4)
- Field (uci) — char(30)
- Field (isbn) — char(13)
- Field (ageLimit) — int(3)
- Field (capacity) — int(3)
- Field (isuueYear) — int(4)
- Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL