호각 관계도
테이블 (14)
Branch
- BranchID — bigint — 기본 키 — NOT NULL
- OrganizationID — bigint — 외래 키 → Organization.OrganizationID — NOT NULL
- BranchName — nvarchar(200) — NOT NULL
- BranchType — int — NOT NULL
- BranchStatus — int — NOT NULL
- ZipCode — varchar(10) — NOT NULL
- Address1 — nvarchar(510) — NOT NULL
- Address2 — nvarchar(510) — NOT NULL
- QRCode — varchar(50)
- QRCodeImageURL — varchar(200)
- Latitude — float
- Longitude — float
- Point — int
- IsDisplay — bit — NOT NULL
- IsAppPush — bit — NOT NULL
- IsSMS — bit — NOT NULL
- IsMail — bit — NOT NULL
- IsNoSendNight — bit — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
Competition
- CompetitionID — bigint — 기본 키 — NOT NULL
- SportID — int — NOT NULL
- ReferenceType — int — NOT NULL
- ReferenceID — bigint — NOT NULL
- CompetitionName — nvarchar(200) — NOT NULL
- CompetitionType — int — NOT NULL
- CompetitionStatus — int — NOT NULL
- StartDate — datetime — NOT NULL
- EndDate — datetime — NOT NULL
- IsDisplay — bit — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
- MainImageURL — varchar(200)
- SubImageURL — varchar(200)
- Point — int
- SearchCount — int
- SeasonPassStatus — int — NOT NULL
- SeasonPassType — int — NOT NULL
- SeasonPassPoint — int
CompetitionPark
- CompetitionID — bigint — 외래 키 → Competition.CompetitionID — NOT NULL
- ParkID — int — 외래 키 → Park.ParkID — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
MatchSchedule
- MatchScheduleID — bigint — 기본 키 — NOT NULL
- CompetitionID — bigint — 외래 키 → Competition.CompetitionID — NOT NULL
- ParkID — int
- SportID — int
- MatchName — nvarchar(200) — NOT NULL
- PlayerType — int
- StartDate — datetime — NOT NULL
- EndDate — datetime — NOT NULL
- Point — int
- IsPanorama — bit — NOT NULL
- IsScoreBoard — bit — NOT NULL
- IsScore — bit — NOT NULL
- ScoreBoardType — int
- MatchStatus — int — NOT NULL
- IsDisplay — bit — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
- IsVod — bit — NOT NULL
- VodStatus — int
MatchScheduleVod
- VodID — bigint — 기본 키 — NOT NULL
- MatchScheduleID — bigint — 외래 키 → MatchSchedule.MatchScheduleID — NOT NULL
- VodType — int — NOT NULL
- VodStatus — int — NOT NULL
- VodTitle — nvarchar(200) — NOT NULL
- VodURL — varchar(500) — NOT NULL
- ThumbnailURL — varchar(500)
- Duration — int
- TotalViewCount — int
- Point — int
- IsDisplay — bit — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
- VodSize — bigint
- VodQuality — int
- IsDownload — bit
MatchScheduleVodDetail
- VodDetailID — bigint — 기본 키 — NOT NULL
- VodID — bigint — 외래 키 → MatchScheduleVod.VodID — NOT NULL
- VodDetailType — int — NOT NULL
- VodDetailStatus — int — NOT NULL
- VodDetailTitle — nvarchar(200) — NOT NULL
- VodDetailURL — varchar(500) — NOT NULL
- ThumbnailURL — varchar(500)
- Duration — int
- TotalViewCount — int
- Point — int
- IsDisplay — bit — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
- VodSize — bigint
- VodQuality — int
- IsDownload — bit
- VodStartAt — int
- VodEndAt — int
- VodResolution — varchar(50)
MatchTeam
- MatchTeamID — int — 기본 키 — NOT NULL
- MatchScheduleID — bigint — 외래 키 → MatchSchedule.MatchScheduleID — NOT NULL
- TeamID — bigint — NOT NULL
- MatchType — int — NOT NULL
- TeamName — nvarchar(200)
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
Member
- MemberID — bigint — 기본 키 — NOT NULL
Organization
- OrganizationID — bigint — 기본 키 — NOT NULL
- SportID — int — NOT NULL
- ReferenceType — int — NOT NULL
- ReferenceID — bigint — NOT NULL
- OrganizationName — nvarchar(200) — NOT NULL
- OrganizationType — int — NOT NULL
- IsDisplay — bit — NOT NULL
- IsAppPush — bit — NOT NULL
- IsSMS — bit — NOT NULL
- IsMail — bit — NOT NULL
- IsNoSendNight — bit — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
- QRCode — varchar(50)
- QRCodeImageURL — varchar(200)
- Latitude — float
- Longitude — float
- SearchCount — int
- BranchCount — int
- BranchStatus — int — NOT NULL
- Point — int
OrganizationMember
- BranchID — bigint — 기본 키 — NOT NULL
- MemberID — bigint — 외래 키 → Member.MemberID — NOT NULL
- OrganizationID — bigint — 외래 키 → Organization.OrganizationID — NOT NULL
- SportID — int
- MemberType — int — NOT NULL
- BCode — varchar(10)
- JoinDate — datetime — NOT NULL
- ApprovalStatus — int — NOT NULL
- ApprovalMemberID — bigint
- ApprovalDate — datetime
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
OrganizationTeam
- BranchID — bigint — 기본 키 — NOT NULL
- TeamID — bigint — 외래 키 → Team.TeamID — NOT NULL
- OrganizationID — bigint — 외래 키 → Organization.OrganizationID — NOT NULL
- MemberID — bigint — NOT NULL
- JoinDate — datetime — NOT NULL
- ApprovalStatus — int — NOT NULL
- ApprovalMemberID — bigint
- ApprovalDate — datetime
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
Park
- ParkID — int — 기본 키 — NOT NULL
- SportID — int — NOT NULL
- ReferenceType — int — NOT NULL
- ReferenceID — bigint — NOT NULL
- ParkName — nvarchar(200) — NOT NULL
- ParkType — int — NOT NULL
- AddressType — int — NOT NULL
- Point — int
- SiGunGuCode — varchar(5)
- ZipCode — varchar(10) — NOT NULL
- Address1 — nvarchar(510) — NOT NULL
- Address2 — nvarchar(510) — NOT NULL
- QRCode — varchar(50)
- QRCodeImageURL — varchar(200)
- Latitude — float
- Longitude — float
- SearchCount — int
- MainImageURL — varchar(200)
- SubImageURL — varchar(200)
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
- StadiumID — varchar(50)
Team
- TeamID — bigint — 기본 키 — NOT NULL
- SportID — int — NOT NULL
- ReferenceType — int — NOT NULL
- ReferenceID — bigint — NOT NULL
- TeamName — nvarchar(200) — NOT NULL
- TeamType — int — NOT NULL
- TeamLevel — int
- ShortName — nvarchar(50)
- TeamColor1 — varchar(20)
- TeamColor2 — varchar(20)
- LogoImageURL — varchar(200)
- CoverImageURL — varchar(200)
- IsDisplay — bit — NOT NULL
- IsAppPush — bit — NOT NULL
- IsSMS — bit — NOT NULL
- IsMail — bit — NOT NULL
- IsNoSendNight — bit — NOT NULL
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime
TeamMember
- MemberID — bigint — 외래 키 → Member.MemberID — NOT NULL
- TeamID — bigint — 외래 키 → Team.TeamID — NOT NULL
- PositionID — int
- MemberType — int — NOT NULL
- JoinType — int — NOT NULL
- UniformNumber — int
- Nickname — nvarchar(50)
- Relationship — int
- PlayerMemberID — bigint
- JoinDate — datetime — NOT NULL
- ApprovalStatus — int — NOT NULL
- ApprovalMemberID — bigint
- ApprovalDate — datetime
- IsDisplay — bit
- IsDelete — bit — NOT NULL
- RegistID — bigint — NOT NULL
- RegistDate — datetime — NOT NULL
- UpdateID — bigint
- UpdateDate — datetime