reebok
테이블 (16)
Untitled (User_SignUpPath_Option)
- Key (Path_ID) — INTEGER — 기본 키 — NOT NULL
- Field (PathName) — VARCHAR(20)
Untitled (Rank)
- Key (RankID) — INTEGER — 기본 키 — NOT NULL
- Field (RankLevel) — VARCHAR(10)
Untitled (Purchase)
- Key (UserID) — VARCHAR(20) — 외래 키 → 사용자.Key — NOT NULL
- Field (Amount) — INTEGER
- Field2 (PurchaseMoney) — BIGINTEGER
Untitled (Couphone)
- Key (CouphoneID) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (CouphoneName) — VARCHAR(30) — NOT NULL
- Field (ExpirationPeriod) — VARCHAR(30)
Untitled (UseRange)
- Key (RangeID) — INTEGER — 기본 키 — NOT NULL
- Field (RangeName) — VARCHAR(20) — NOT NULL
Untitled (UseCondition)
- Key (ConditionId) — INTEGER — 기본 키 — NOT NULL
- Field (ConditionName) — VARCHAR(30)
Untitled (UseOverlapping)
- Key (OverlappingID) — INTEGER — 기본 키 — NOT NULL
- Field (OverlappingOrNot) — VARCHAR(20) — NOT NULL
Untitled (Couphone_Condition)
- Key (CouphoneID) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (RangeID) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Key (ConditionId) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Key (OverlappingID) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
Untitled (UserDeposit)
- Key (UserID) — VARCHAR(20) — 외래 키 → 사용자.Key — NOT NULL
- Field (Date) — DATE
- Field (Type) — VARCHAR(30)
- Field2 (Content) — VARCHAR(30)
- Field (Price) — BIGINTEGER
Untitled (DepositHistory)
Untitled (UserPoint)
- Key (UserID) — VARCHAR(20) — 외래 키 → 사용자.Key — NOT NULL
- Field (Date) — DATE
- Field (Type) — VARCHAR(20)
- Field (Content) — VARCHAR(20)
- Field (ExpriationPeriod) — VARCHAR(30)
- Field (PointAmount) — BIGINTEGER
Untitled (Kakao)
- Key (KakaoID) — INTEGER — 기본 키 — NOT NULL
- Field (KakaoOrNot) — VARCHAR(10)
Untitled (User_Kakao)
- Key (UserID) — VARCHAR(20) — 외래 키 → 사용자.Key — NOT NULL
- Key (KakaoID) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
사용자 (User)
- Key (UserID) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (Name) — VARCHAR(30) — NOT NULL
- Field2 (Email) — VARCHAR(30) — NOT NULL
- Field3 (PhoneNumber) — VARCHAR(20) — NOT NULL
- Field4 (Number) — VARCHAR(20)
- Field5 (Address) — VARCHAR(50)
- Field6 (Sex) — INTEGER — NOT NULL
- Field7 (Birthday) — VARCHAR(15) — NOT NULL
- Field (SignUpPath) — INTEGER — NOT NULL