test
Tables (9)
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_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 — =