시분론

테이블 (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