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