호각 관계도

테이블 (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