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 (UserCouphone)

    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 (PointHistory)

        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