Ezen
Tables (4)
Member
- id (Key) — Long — Primary key — NOT NULL
- loginId (Field) — String
- password (Field2) — String
- name (Field3) — String
- email (Field4) — String
- phone (Field5) — String
- address (Field6) — String
- createDate (Field7) — datetime
- updateDate (Field8) — datetime
Order
- id (Key) — Long — Primary key — NOT NULL
- totalPrice (Field6) — decimal
- buyCount (Field9) — int
- createDate (Field) — datetime
- updateDate (Field2) — datetime
- memberId (Key2) — Long — Foreign key → Member.id — NOT NULL
OrderProduct
- id (Key) — Long — Primary key — NOT NULL
- orderId (Field) — Long — Foreign key → Order.id — NOT NULL
- productId (Field2) — Long — Foreign key → Product.id — NOT NULL
- discountPrice (Field3) — decimal
- createDate (Field4) — datetime
- updateDate (Field5) — datetime
Product
- id (Key) — Long — Primary key — NOT NULL
- kind (Field) — String
- name (Field2) — String
- price (Field3) — int
- author (Field5) — String
- publisher (Field6) — String
- publishingDate (Field7) — String
- image (Field8) — String
- discription (Field9) — int
- discountRate (Field10) — double
- createDate (Field4) — datetime
- updateDate (Field12) — datetime