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