ㅅㄷㄴㅅ

Tables (10)

Ct_Strava

  • CtID — varchar(50) — Primary key — NOT NULL
  • CtName — nvarchar(100) — NOT NULL
  • CtType — varchar(10) — NOT NULL
  • CustNo — char(16) — NOT NULL
  • StravaID — varchar(50) — NOT NULL
  • Distance — varchar(50) — NOT NULL
  • MovingTime — varchar(50) — NOT NULL
  • SYYYYMM — char(6) — NOT NULL
  • StartDate — datetime — NOT NULL
  • AverageSpeed — varchar(50) — NOT NULL
  • MaxSpeed — varchar(50) — NOT NULL
  • PhotoUrl — varchar(4000)
  • ChangePointStatus — char(2)
  • ChangeDistance — varchar(50)
  • UseYn — char(1)
  • UseYnDesc — nvarchar(50)
  • ExtinctionYn — char(1)
  • InsDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaAward

  • Seq — int — Primary key — NOT NULL
  • CustNo — varchar(16) — NOT NULL
  • CustName — nvarchar(50) — NOT NULL
  • CustSex — char(1) — NOT NULL
  • CellNo — varchar(15) — NOT NULL
  • WebID — varchar(20) — NOT NULL
  • SYYYYMM — char(6) — NOT NULL
  • Rank — int — NOT NULL
  • InsDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaBlackList

  • Idx — int — Primary key — NOT NULL
  • CustNo — nvarchar(16) — NOT NULL
  • InsDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaFriend

  • Seq — int — Primary key — NOT NULL
  • CustNo — char(16) — NOT NULL
  • StravaID — varchar(50) — NOT NULL
  • FCustNo — varchar(16)
  • FStravaID — varchar(50) — NOT NULL
  • InsDate — datetime
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaLastRecord

  • Seq — int — Primary key — NOT NULL
  • CustNo — varchar(16) — NOT NULL
  • StravaID — varchar(50)
  • LastUptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaPhoto

  • PhotoID — varchar(50) — Primary key — NOT NULL
  • CtID — varchar(50) — NOT NULL
  • PhotoUrl — varchar(300) — NOT NULL
  • Caption — nvarchar(100)
  • Width — int
  • Height — int
  • InsDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaRanking

  • SYYYYMM — char(6) — Primary key — NOT NULL
  • CustSex — char(1) — Primary key — NOT NULL — 성별
  • CustNo — char(16) — Primary key — NOT NULL — 고객번호
  • WebId — varchar(50) — Primary key — NOT NULL — 웹아이디
  • TotDistance — decimal(18, 2) — NOT NULL — 총거리
  • UptDate — datetime — NOT NULL — 년월
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaToPointHis

  • PointHisIdx — int — Primary key — NOT NULL
  • CustNo — char(16) — NOT NULL
  • Distance — int — NOT NULL
  • Point — int — NOT NULL
  • InsDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaToPointHisDtl

  • Seq — int — Primary key — NOT NULL
  • PointHisIdx — int — NOT NULL
  • CtID — varchar(50) — NOT NULL
  • Distance — varchar(50) — NOT NULL
  • InsDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Ct_StravaToken

  • StravaTokenIdx — int — Primary key — NOT NULL
  • CustNo — char(16) — NOT NULL
  • StravaID — varchar(50) — NOT NULL
  • AccessToken — varchar(50) — NOT NULL
  • RefreshToken — varchar(50) — NOT NULL
  • InsDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =