ddasdf

Tables (10)

Address

  • id — BIGINT — Primary key — NOT NULL
  • userAddress — VARCHAR(100) — NOT NULL
  • userId — BIGINT — NOT NULL
  • zipcode — VARCHAR(10) — NOT NULL
  • defaultAddress — BOOLEAN — NOT NULL

Administrator

  • id — BIGINT — Primary key — NOT NULL
  • adminName — VARCHAR(10) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(50) — NOT NULL

Cart

  • id — BIGINT — Primary key — NOT NULL
  • productId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • quantity — BIGINT — NOT NULL

Delivery

  • id — BIGINT — Primary key — NOT NULL
  • orderItemId — BIGINT — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • zipcode — VARCHAR(10) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • receiver — VARCHAR(15) — NOT NULL
  • status — VARCHAR(10) — NOT NULL

OrderItem

  • id — BIGINT — Primary key — NOT NULL
  • orderId — BIGINT — NOT NULL
  • productId — BIGINT — NOT NULL
  • count — BIGINT — NOT NULL
  • orderPrice — BIGINT — NOT NULL
  • sellerId — BIGINT — NOT NULL
  • status — VARCHAR(10) — NOT NULL

Orders

  • id — BIGINT — Primary key — NOT NULL
  • orderDate — DATETIME — NOT NULL
  • userId — BIGINT — NOT NULL
  • paymentId — BIGINT — NOT NULL
  • totalPrice — BIGINT — NOT NULL

Payment

  • id — BIGINT — Primary key — NOT NULL
  • totalPrice — BIGINT — NOT NULL
  • payMethod — VARCHAR(10) — NOT NULL
  • payCompany — VARCHAR(20) — NOT NULL

Seller

  • id — BIGINT — Primary key — NOT NULL
  • sellerName — VARCHAR(50) — NOT NULL
  • sellerNumber — VARCHAR(50) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(20) — NOT NULL

Users

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(10) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL

product

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • detail — VARCHAR(3000) — NOT NULL
  • sellerId — BIGINT — NOT NULL
  • productPrice — BIGINT — NOT NULL
  • thumbnail — VARCHAR(500) — NOT NULL
  • stock — BIGINT — NOT NULL