NEMOAPP ERD V0.2

Tables (171)

AdministrativeDivisionGeometries (Untitled50)

  • (Code) — Foreign key → AdministrativeDivisions.Code — NOT NULL

AdministrativeDivisions (관리구역)

  • (Code) — Primary key — NOT NULL

AgentHistories (Untitled46)

  • (Id) — Primary key — NOT NULL
  • (AgentId) — Foreign key → Agents.[Id] — NOT NULL
  • (CategoryId) — Foreign key → AgentHistoryCategories.Id — NOT NULL
  • (TaskId) — Foreign key → AgentHistoryTasks.Id — NOT NULL
  • (OperatorId) — Foreign key → AspNetUsers.[Id] — NOT NULL

AgentHistoryCategories (Untitled47)

  • (Id) — Primary key — NOT NULL

AgentHistoryTasks (Untitled48)

  • (Id) — Primary key — NOT NULL

AgentInquiries (Untitled49)

  • (Id) — Primary key — NOT NULL
  • (AgentId) — Foreign key → Agents.[Id] — NOT NULL
  • (UserId) — Foreign key → AspNetUsers.[Id] — NOT NULL

AgentPartUserHistories (Untitled52)

  • (EditedDateUtc) — Primary key — NOT NULL
  • (Id2) — Primary key — NOT NULL
  • (PartId) — Foreign key → AgentParts.Id — NOT NULL
  • (DeletedOperatorId) — AspNetUsers
  • (EditedOperatorId) — AspNetUsers
  • (CreatedOperatorId) — AspNetUsers
  • (ManagerId) — AspNetUsers

AgentPartUsers (Untitled54)

  • ([Id]) — Foreign key → AspNetUsers.[Id] — NOT NULL
  • (PartId) — Foreign key → AgentParts.Id — NOT NULL

AgentParts (Untitled53)

  • (Id) — Primary key — NOT NULL

AgentPenalties (중개사 경고)

  • ([Id]) — Primary key — NOT NULL
  • ([AgentId]) — Foreign key → Agents.[Id] — NOT NULL
  • ([OperatorId]) — Foreign key → AspNetUsers.[Id] — NOT NULL

AgentRanks (Untitled55)

  • ([Id]) — Foreign key → Agents.[Id] — NOT NULL

AgentUsers (부동산유저)

  • ([Id]) — Foreign key → AspNetUsers.[Id] — NOT NULL
  • ([AgentId]) — Foreign key → Agents.[Id] — NOT NULL
  • ([ProfileInfoId]) — Foreign key — NOT NULL

Agents (부동산정보)

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

ApartmentRentHistories (안쓰임)

  • Field (Id)
  • Field (BuildingManagementSerialNumber)

ApartmentSaleHistories (안쓰임115)

  • Field (Id)
  • Field2 (BuildingManagementSerialNumber)

ApiLogs (Untitled115)

    Applications (Untitled85)

    • (Name) — Primary key — NOT NULL

    ArticleFavorites (Untitled6)

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

    ArticleInquiries (Untitled57)

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

    ArticleItemGroups (그룹)

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

    ArticleItemReservations (Untitled8)

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

    ArticleItems (매물항목)

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

    ArticleOfficeInquiries (Untitled37)

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

    ArticleOfficeNotifications (매물사무실통지)

    • ([Id]) — Primary key — NOT NULL
    • ([ArticleOfficeInquiryId]) — Foreign key → ArticleOfficeInquiries.[Id] — NOT NULL
    • ([ArticleId]) — Foreign key → Articles.[Id] — NOT NULL
    • ([UserId]) — Foreign key → AspNetUsers.[Id] — NOT NULL

    ArticlePriceHistories (Untitled58)

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

    ArticlePrices (매물가격)

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

    ArticleRanks (Untitled59)

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

    ArticleRelatedCodes (Untitled2)

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

    ArticleReports (Untitled60)

    • (Id) — Primary key — NOT NULL
    • (ArticleId) — Foreign key → Articles.[Id] — NOT NULL
    • (ReporterId) — AspNetUsers
    • (OperatorId) — AspNetUsers

    ArticleShares (Untitled61)

    • (ShareCompanyType) — Primary key — NOT NULL
    • (ArticleId) — Foreign key → ArticleItems.[Id] — NOT NULL

    ArticleStoreInquiries (매물상가문의)

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

    ArticleStoreNotifications (매물상가통지)

    • ([Id]) — Primary key — NOT NULL
    • ([UserId]) — Foreign key → AspNetUsers.[Id] — NOT NULL
    • ([ArticleId]) — Foreign key → Articles.[Id] — NOT NULL
    • ([ArticleStoreInquiryId]) — Foreign key → ArticleStoreInquiries.[Id] — NOT NULL

    ArticleStoreTrades (Untitled40)

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

    ArticleViewCountDays (Untitled27)

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

    ArticleViewCountRegionSummaries (Untitled62)

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

    ArticleViewCountSummaries (Untitled28)

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

    Articles (매물정보)

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

    AspNetRoleClaims (Untitled63)

    • (Id) — Primary key — NOT NULL
    • (RoleId) — Foreign key → AspNetRoles.[Id] — NOT NULL

    AspNetRoles (역할정의)

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

    AspNetUserClaims (Untitled64)

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

    AspNetUserLogins (제휴인증)

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

    AspNetUserRoles (역할매핑)

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

    AspNetUserTokens (Untitled116)

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

    AspNetUsers (네모앱 사용자)

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

    BigData_CommercialDistrictMaster (Untitled117)

      BigData_CommercialDistrictPayPerPayments (Untitled118)

        BigData_CommercialDistrictSales (Untitled119)

          BigData_CommercialDistrictSalesByAges (Untitled120)

            BigData_CommercialDistrictSalesByDayofWeeks (Untitled121)

              BigData_CommercialDistrictSalesByTimes (Untitled122)

                BigData_CommercialDistrictSectors (Untitled123)

                  BigData_CoworkingSpacePrices (Untitled124)

                    BigData_FloatingPopulationDistricts (Untitled125)

                      BigData_FloatingPopulationPerHours (Untitled126)

                        BigData_FloatingPopulationPerMonths (Untitled127)

                          BigData_FloatingPopulationPerWeekdays (Untitled128)

                            BigData_FloatingPopulationRegionPerMonths (Untitled129)

                              BigData_Households (Untitled130)

                                BigData_LivingPopulation (Untitled131)

                                  BigData_SmallMerchants (Untitled132)

                                    BigData_SubwayStationPassengerHours (Untitled133)

                                      BigData_SubwayStationPassengerMonths (Untitled134)

                                        BlockedAgents (Untitled56)

                                        • (Id) — Primary key — NOT NULL
                                        • (AgentId) — Foreign key → Agents.[Id] — NOT NULL

                                        BranchRanks (Untitled)

                                        • (Id) — Foreign key — NOT NULL
                                        • Field

                                        BuildingArticles (Untitled12)

                                        • ([Id]) — Primary key — NOT NULL
                                        • ([BuildingInfoId]) — Foreign key → BuildingInfo.[Id] — NOT NULL

                                        BuildingChoiceDatas (Untitled14)

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

                                        BuildingDataStatus (빌딩데이터상태)

                                        • ([Id]) — Primary key — NOT NULL
                                        • ([BuildingInfoId]) — Foreign key → BuildingInfo.[Id] — NOT NULL

                                        BuildingFavorites (Untitled16)

                                        • ([Id]) — Primary key — NOT NULL
                                        • ([BuildingInfoId]) — Foreign key → BuildingInfo.[Id] — NOT NULL

                                        BuildingGeometry (Untitled3)

                                        • Key (Id) — Primary key — NOT NULL
                                        • Field (BuildingInfoId)
                                        • Field

                                        BuildingInfo (빌딩정보2)

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

                                        BuildingInfoMemos (Untitled135)

                                        • Key (Id) — Primary key — NOT NULL
                                        • Field (BuildingInfoId)
                                        • Field

                                        BuildingInquiries (빌딩문의)

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

                                        BuildingLessorInfo (Untitled136)

                                        • Key (Id) — Primary key — NOT NULL
                                        • Field (BuildingInfoId)

                                        BuildingNotifications (Untitled30)

                                        • ([Id]) — Primary key — NOT NULL
                                        • ([BuildingInquiryId]) — Foreign key → BuildingInquiries.[Id] — NOT NULL
                                        • ([BuildingInfoId]) — Foreign key → BuildingInfo.[Id] — NOT NULL
                                        • ([ArticleId]) — Foreign key → Articles.[Id] — NOT NULL
                                        • ([UserId]) — Foreign key → AspNetUsers.[Id] — NOT NULL

                                        BuildingPhotos (Untitled17)

                                        • ([Id]) — Primary key — NOT NULL
                                        • (BuildingInfoId) — Foreign key → BuildingInfo.[Id] — NOT NULL

                                        BuildingPoint (Untitled11)

                                        • ([Id]) — Primary key — NOT NULL
                                        • ([BuildingInfoId]) — Foreign key → BuildingInfo.[Id] — NOT NULL

                                        BuildingRegisterFloors (Untitled137)

                                          BuildingRegisterHeadlines (Untitled25)

                                            BuildingSubwayStations (Untitled15)

                                            • ([Id]) — Primary key — NOT NULL
                                            • ([BuildingInfoId]) — Foreign key → BuildingInfo.[Id] — NOT NULL
                                            • ([SubwayStationsId]) — Foreign key — NOT NULL

                                            BuildingWorkManagerStatus (Untitled138)

                                            • Key (Id) — Primary key — NOT NULL
                                            • Field (BuildingInfoId)
                                            • Field (ManagerId)

                                            and 91 more tables