시분론
테이블 (17)
AcademicSubscriptionDB (CopyOfUntitled13)
- SubscriptionID (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- description (Field2) — text
- type (Field3) — char(10)
Department(SeoulCityHall) (Untitled3)
- departmentID (Key) — int(20) — 기본 키 — NOT NULL
- name (Field) — char(20)
- explaination (Field2) — text
Eungdapso (Untitled7)
- eungdapsoID (Key) — char(30) — 기본 키 — NOT NULL
- civilComplaintContent (Field) — text
- contentHits (Field2) — int(20)
- period (Field3) — date
Finder-Data (Untitled15)
- IssueNumber (Key) — char(30) — 외래 키 → IssueFInder.IssueNumber — NOT NULL
- opengovSeoulID (Key2) — char(30) — 외래 키 → opengovSeoul.opengovSeoulID — NOT NULL
- eungdapsoID (Key3) — char(30) — 외래 키 → Eungdapso.eungdapsoID — NOT NULL
- naverTrendID (Key4) — char(30) — 외래 키 → NaverTrend.naverTrendID — NOT NULL
- seoulDataID (Key5) — char(30) — 외래 키 → seoulData.seoulDataID — NOT NULL
- seoulHomePageID (Key6) — char(30) — 외래 키 → seoulHomePage.seoulHomePageID — NOT NULL
- period (Field) — date
IssueFInder (Untitled2)
- IssueNumber (Key) — char(30) — 기본 키 — NOT NULL
- issueName (Field2) — char(30)
- issueInterest (Field) — int(10)
- period (Field3) — date
Libary-Content (Untitled14)
- dbID (Key6) — char(30) — 외래 키 → SeoulLibaryContent.dbID — NOT NULL
- CollectionID (Key) — char(30) — 외래 키 → SeoulLibraryCollection.CollectionID — NOT NULL
- ContentID (Key2) — char(30) — 외래 키 → SeoulReferenceRoom.ContentID — NOT NULL
- RepositoryID (Key3) — char(30) — 외래 키 → SeoulOAKRepository.RepositoryID — NOT NULL
- SubscriptionID (Key4) — char(30) — 외래 키 → AcademicSubscriptionDB.SubscriptionID — NOT NULL
- SiteLinkID (Key5) — char(30) — 외래 키 → SiteLink.SiteLinkID — NOT NULL
- period (Field) — date
NaverTrend (Untitled6)
- naverTrendID (Key) — char(30) — 기본 키 — NOT NULL
- popularSearchWord (Field3) — text
- ageGroup (Field) — text
- locationGruop (Field4) — text
- period (Field2) — date
SeoulLibaryContent (Untitled4)
- dbID (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- subject (Field3) — char(20)
- keyWord (Field2) — char(20)
- IssueNumber (Key2) — char(30) — 외래 키 → IssueFInder.IssueNumber — NOT NULL
SeoulLibraryCollection (Untitled11)
- CollectionID (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- description (Field3) — text
- type (Field2) — char(10)
SeoulOAKRepository (Untitled13)
- RepositoryID (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- description (Field2) — text
- type (Field3) — char(10)
SeoulReferenceRoom (Untitled12)
- ContentID (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- description (Field3) — text
- type (Field2) — char(10)
SiteLink (CopyOfCopyOfUntitled13)
- SiteLinkID (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(20)
- description (Field2) — text
- type (Field3) — char(10)
SupportPolicyData (Untitled)
- modelID (Key) — char(30) — 기본 키 — NOT NULL
- issueName (Field) — char(30)
- period (Field2) — date
- IssueNumber (Key2) — char(30) — 외래 키 → IssueFInder.IssueNumber — NOT NULL
- dbID (Key3) — char(30) — 외래 키 → SeoulLibaryContent.dbID — NOT NULL
Work_On (Untitled5)
- modelID (Key) — char(30) — 외래 키 → SupportPolicyData.modelID — NOT NULL
- departmentID (Key2) — int(20) — 외래 키 → Department(SeoulCityHall).departmentID — NOT NULL
- policy (Field3) — text
- workPeriod (Field2) — date
opengovSeoul (Untitled8)
- opengovSeoulID (Key) — char(30) — 기본 키 — NOT NULL
- popularSearchWord (Field) — text
- popularContent (Field2) — text
- ageGroup (Field3) — text
- period (Field4) — date
seoulData (Untitled10)
- seoulDataID (Key) — char(30) — 기본 키 — NOT NULL
- popularSearchWord (Field) — text
- period (Field2) — date
seoulHomePage (Untitled9)
- seoulHomePageID (Key) — char(30) — 기본 키 — NOT NULL
- searchWord (Field) — text
- searchVolume (Field2) — int(20)
- period (Field3) — date