e-commerce

Tables (9)

Member (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — varchar
  • email (Field2) — varchar
  • phone_number (Field3) — varchar
  • address (Field4) — varchar
  • nickname (Field5) — varchar
  • password (Field6) — varchar
  • createdAt (Field7) — LocalDateTime
  • updatedAt (Field8) — LocalDateTime
  • deletedAt (Field9) — LocalDateTime

Order (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → Member.id — NOT NULL
  • shippingInfo_id (Key4) — BIGINT — Foreign key → ShippingInfo.id — NOT NULL
  • total_amount (Field) — BIGINT
  • order_state (Field2) — ENUM
  • orderAt (Field3) — LocalDateTime
  • createdAt (Field4) — LocalDateTime
  • updatedAt (Field5) — LocalDateTime
  • deletedAt (Field6) — LocalDateTime

OrderLine (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • order_id (Key2) — BIGINT — Foreign key → Order.id — NOT NULL
  • member_id (Key22) — BIGINT — Foreign key → Order.member_id — NOT NULL
  • product_id (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
  • shipingInfo_id (Key4) — BIGINT — Foreign key → Order.shippingInfo_id — NOT NULL
  • time_deal_id (Key5) — BIGINT — Foreign key → ProductTimeDeal.id — NOT NULL
  • price (Field) — BIGINT
  • quatity (Field2) — BIGINT
  • amounts (Field3) — BIGINT

OrderState (Untitled6)

  • payment_waiting (Field)
  • preparing (Field2)
  • shipped (Field3)
  • delivering (Field4)
  • delivery_completed (Field5)
  • canceled (Field6)

Product (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — varchar
  • description (Field2) — varchar
  • price (Field3) — BIGINT
  • stock (Field5) — BIGINT
  • image_url (Field4) — BIGINT
  • createdAt (Field6) — LocalDateTime
  • updatedAt (Field7) — LocalDateTime
  • deletedAt (Field8) — LocalDateTime

ProductTimeDeal (CopyOfUntitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — varchar
  • description (Field2) — varchar
  • price (Field3) — BIGINT
  • stock (Field5) — BIGINT
  • image_url (Field4) — BIGINT
  • createdAt (Field6) — LocalDateTime
  • updatedAt (Field7) — LocalDateTime
  • deletedAt (Field8) — LocalDateTime
  • start_time (Field9) — LocalDateTime
  • end_time (Field10) — LocalDateTime
  • discount_percent (Field11) — Float

ShippingInfo (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • receiver_name (Field) — varchar
  • receiver_phone_number (Field2) — varchar
  • shipping_address1 (Field3) — varchar
  • shipping_address2 (Field4) — varchar
  • shipping_zip_code (Field5) — varchar
  • createdAt (Field6) — LocalDateTime
  • updatedAt (Field7) — LocalDateTime
  • deletedAt (Field8) — LocalDateTime

WishList (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → Member.id — NOT NULL

WishListLine (Untitled8)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • wishList_id (Key2) — BIGINT — Foreign key → WishList.id — NOT NULL
  • member_id (Key22) — BIGINT — Foreign key → WishList.member_id — NOT NULL
  • product_id (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
  • quantity (Field) — BIGINT
  • price (Field2) — BIGINT
  • amounts (Field3) — BIGINT