NEMOAPP ERD V0.1

Tables (30)

[dbo].[AdministrativeDivisions] (관리구역)

  • (Code) — Primary key — NOT NULL — 읍면동 코드로 보임

[dbo].[Agents] (부동산정보)

  • ([Id]) — Primary key — NOT NULL
  • ([BuildingManagementSerialNumber]) — Foreign key → [dbo].[Buildings].[BuildingManagementSerialNumber] — NOT NULL
  • ([MunicipalityCode]) — Foreign key → [dbo].[Municipalities].[Code] — NOT NULL
  • ([RegistrationOperatorId]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL
  • ([VestedRightsOperatorId]) — [dbo].[AspNetUsers] 참조
  • ([ManagementOperatorId]) — [dbo].[AspNetUsers] 참조
  • ([ProfileInfoId]) — Foreign key → [dbo].[ProfileInfos].[Id] — NOT NULL

[dbo].[ArticleFavorites] (Untitled6)

  • ([ArticleFavoriteType]) — Primary key — NOT NULL — 즐겨찾기, 최근 본 매물, 최근 연락한 매물
  • ([ArticleId]) — Foreign key → [dbo].[Articles].[Id] — NOT NULL
  • ([UserId]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL

[dbo].[ArticleItemGroups] (그룹)

  • ([Id]) — Primary key — NOT NULL
  • ([AgentId]) — Foreign key → [dbo].[Agents].[Id] — NOT NULL
  • ([CompanyId]) — Foreign key → [dbo].[CoworkingSpaceCompanies].[Id] — NOT NULL
  • ([OperatorId]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL
  • ([UserId]) — [dbo].[AspNetUsers] 참조
  • ([ReceptionOperatorId]) — [dbo].[AspNetUsers] 참조
  • ([RegistrationOperatorId]) — [dbo].[AspNetUsers] 참조

[dbo].[ArticleItemReservations] (Untitled8)

  • ([Id]) — Primary key — NOT NULL
  • ([AgentId]) — Foreign key → [dbo].[Agents].[Id] — NOT NULL
  • ([OperatorId]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL
  • ([SubwayStationId]) — Foreign key → [dbo].[SubwayStations].Id — NOT NULL
  • ([SubmunicipalityCode]) — Foreign key → [dbo].[Submunicipalities].[Code] — NOT NULL

[dbo].[ArticleItems] (매물항목)

  • ([Id]) — Primary key — NOT NULL
  • ([GroupId]) — Foreign key → [dbo].[ArticleItemGroups].[Id] — NOT NULL
  • ([SubmunicipalityCode]) — Foreign key → [dbo].[Submunicipalities].[Code] — NOT NULL
  • ([SubwayStationId]) — Foreign key → [dbo].[SubwayStations].Id — NOT NULL
  • ([ReferenceItemId]) — 자기참조

[dbo].[ArticlePrices] (매물가격)

  • ([ArticleId]) — Foreign key → [dbo].[Articles].[Id] — NOT NULL

[dbo].[ArticleRelatedCodes] (Untitled2)

  • ([RelatedCode]) — Primary key — NOT NULL
  • ([ArticleType]) — Primary key — NOT NULL
  • ([ArticleId]) — Foreign key → [dbo].[Articles].[Id] — NOT NULL

[dbo].[Articles] (매물정보)

  • ([Id]) — Primary key — NOT NULL
  • ([BuildingManagementSerialNumber]) — Foreign key → [dbo].[Buildings].[BuildingManagementSerialNumber] — NOT NULL
  • ([UserId]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL
  • ([ComplexId]) — Foreign key → [dbo].[Complexes].[Id] — NOT NULL — 죄다 NULL
  • ([ComplexStructureId]) — Foreign key → [dbo].[ComplexStructures].[Id] — NOT NULL — 죄다 NULL

[dbo].[AspNetRoles] (역할정의)

  • ([Id]) — Primary key — NOT NULL

[dbo].[AspNetUserLogins] (제휴인증)

  • ([LoginProvider]) — Primary key — NOT NULL
  • ([ProviderKey]) — Primary key — NOT NULL
  • ([UserId]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL

[dbo].[AspNetUserRoles] (역할매핑)

  • ([RoleId]) — Foreign key → [dbo].[AspNetRoles].[Id] — NOT NULL
  • ([UserId]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL

[dbo].[AspNetUsers] (네모앱 사용자)

  • ([Id]) — Primary key — NOT NULL

[dbo].[BigData_CommercialDistrictMaster] (Untitled)

  • ([SubmunicipalityCode]) — Primary key — NOT NULL
  • ([CommercialDistrictType]) — Primary key — NOT NULL
  • ([CommercialDistrictCode]) — Primary key — NOT NULL

[dbo].[BigData_FloatingPopulationDistricts] (Untitled3)

  • ([AggregationDistrictCode]) — Primary key — NOT NULL
  • ([SubmunicipalityCode]) — Primary key — NOT NULL

[dbo].[Buildings] (빌딩정보)

  • ([BuildingManagementSerialNumber]) — Primary key — NOT NULL
  • ([SubmunicipalityCode]) — Foreign key → [dbo].[Submunicipalities].[Code] — NOT NULL
  • ([ProvinceCode]) — Foreign key → [dbo].[Provinces].[Code] — NOT NULL
  • ([MunicipalityCode]) — Foreign key → [dbo].[Municipalities].[Code] — NOT NULL

[dbo].[ComplexStructures] (Untitled5)

  • ([Id]) — Primary key — NOT NULL
  • ([ComplexId]) — Foreign key → [dbo].[Complexes].[Id] — NOT NULL

[dbo].[Complexes] (Untitled4)

  • ([Id]) — Primary key — NOT NULL

[dbo].[CoworkingSpaceCompanies] (공유공간회사)

  • ([Id]) — Primary key — NOT NULL

[dbo].[Municipalities] (구)

  • ([Code]) — Primary key — NOT NULL
  • ([ProvinceCode]) — Foreign key → [dbo].[Provinces].[Code] — NOT NULL

[dbo].[ProfileInfos] (부동산Profile)

  • ([Id]) — Primary key — NOT NULL

[dbo].[Provinces] (시도)

  • ([Code]) — Primary key — NOT NULL

[dbo].[RegionStatisticsPrices] (지역 가격 통계 정보)

  • (Code) — Primary key — NOT NULL
  • (Type) — Primary key — NOT NULL

[dbo].[SafePhoneNumbers] (Untitled7)

  • ([PhoneNumber]) — Primary key — NOT NULL — 0504번호

[dbo].[SalesGroupUsers] (Untitled9)

  • ([Id]) — Foreign key → [dbo].[AspNetUsers].[Id] — NOT NULL
  • ([GroupId]) — Foreign key → [dbo].[SalesGroups].[Id] — NOT NULL

[dbo].[SalesGroups] (Untitled10)

  • ([Id]) — Primary key — NOT NULL
  • ([JoinedProvinceLimits]) — 지역결합제한?

[dbo].[Submunicipalities] (읍면동)

  • ([Code]) — Primary key — NOT NULL
  • ([GroupCode]) — Primary key — NOT NULL
  • ([MunicipalityCode]) — Foreign key → [dbo].[Municipalities].[Code] — NOT NULL

[dbo].[SubwayStationArticles] (지하철역 매물)

  • ([SubwayStationId]) — Primary key — NOT NULL
  • ([ArticleId]) — Foreign key → [dbo].[Articles].[Id] — NOT NULL

[dbo].[SubwayStationLines] (지하철 라인 코드)

  • ([StationId]) — Primary key — NOT NULL
  • ([LineCode]) — Primary key — NOT NULL

[dbo].[SubwayStations] (지하철정보)

  • (Id) — Primary key — NOT NULL