database

테이블 (3)

Untitled (Mypage)

  • Key (MyPageID) — VarChar(20 — 기본 키 — NOT NULL
  • Key (ID) — Varchar(20) — 외래 키 → 회원.Key — NOT NULL
  • Key (GradeID) — Integer — 외래 키 → Untitled.Key — NOT NULL
  • Field (CouponID) — Integer
  • Field (Point) — Integer
  • Field (OrderHistory)

Untitled (Grade)

  • Key (GradeID) — Integer — 기본 키 — NOT NULL
  • Field (GradeName) — nVarchar(10)
  • Field (ExtraDiscount) — Decimal(2,3)
  • Field (ExtraDiscountDetail) — nVarChar(30)
  • Field (DuplicateDiscount) — Decimal(2,3)
  • Field (DuplicateDiscountDetail) — nVarChar(30)
  • Field (AdditionalSavings) — Decimal(2,3)
  • Field (AdditionalSavingsDetail) — nVarChar(30)

회원 (Consumer)

  • Key (ID) — Varchar(20) — 기본 키 — NOT NULL
  • Field (Password) — Varchar(20)
  • Field2 (Name) — nVarchar(20)
  • Field (Email) — VarChar(30)
  • Field (Gender) — nVarChare(10)
  • Field (BirthDay) — DateTime
  • Field (Address) — nVarChar(30)
  • Field (Telephone) — Varchar(15)
  • Field (HousePhone) — VarChar(15)