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