NEMOAPP ERD V0.3
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