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)