myfranchise

Tables (19)

areas (행정동 코드)

  • _id (Key5) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

businessitems (업종)

  • _id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

busstops (버스정류장)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

companies (본사)

  • _id (Key) — Primary key — NOT NULL
  • _id (Key2) — Foreign key → franchises._id — NOT NULL
  • Field
  • Field2
  • Field3
  • _id (Key3) — Foreign key → companyarchives._id — NOT NULL

companyarchives (본사(정보공개서))

  • _id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

consumptionbusinesses (행정동별 업종별 매출)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

consumptiongenderages (행정동별 성연령별 매출)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

consumptions (행정동별 매출)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

franchisearchives (프랜차이즈(정보공개서))

  • _id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

franchisees (가맹점)

  • _id (Key) — Primary key — NOT NULL
  • _id (Key2) — Foreign key → franchises._id — NOT NULL
  • Field
  • Field2
  • Field3

franchises (프랜차이즈)

  • _id (Key) — Primary key — NOT NULL
  • companies (Key2) — Foreign key → franchisearchives._id — NOT NULL
  • Field
  • Field2
  • Field3
  • businessItems (Key3) — Foreign key → businessitems._id — NOT NULL

hospitals (병원)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

householdmembers (?)

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Field
  • Key (Key3) — Foreign key → households.Key — NOT NULL

households (배후세대)

  • Key — Primary key — NOT NULL
  • Field

kindergartens (유치원)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

populations (행정동별 인구)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

schools (학교)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

subways (지하철역)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL

universities (대학)

  • Key — Primary key — NOT NULL
  • Field
  • _id (Key5) — Foreign key → areas._id — NOT NULL