erd1

Tables (7)

Address

  • idx — INT — Primary key — NOT NULL
  • address — VARCHAR(50)
  • detailAddress — VARCHAR(50)
  • alias — VARCHAR(50)
  • useridx — INT — Foreign key → User.idx
  • createAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(7)

Orders

  • idx — INT — Primary key — NOT NULL
  • address — VARCHAR(100) — Foreign key → Address.address
  • storeIdx — INT
  • orderPrice — INT
  • deliveryPrice — INT
  • discountPrice — INT
  • totalPrice — INT

PRODUCT

  • product_id — INT — Primary key — NOT NULL
  • Field — VARCHAR(50)
  • product_price — INT
  • product_introduction — VARCHAR(500)
  • product_remain — INT

REVIEW

  • review_id — INT — Primary key — NOT NULL
  • review_contents — VARCHAR(500)
  • review_rating — DOUBLE
  • store_id — INT — Foreign key → STORE.store_id
  • product_id — INT
  • review_img — TEXT
  • review_created — DATETIME
  • review_status — BOOL

STORE

  • store_id — INT — Primary key — NOT NULL
  • store_name — VARCHAR(50)
  • store_phone — VARCHAR(20)
  • store_address — VARCHAR(80)
  • store_CEO_name — VARCHAR(10)
  • store_introduction — VARCHAR(500)
  • store_rocket — BOOL
  • store_delivery_time — VARCHAR(20)

User

  • idx — INT — Primary key — NOT NULL
  • email — VARCHAR(45)
  • password — VARCHAR(255)
  • userName — VARCHAR(30)
  • phone — VARCHAR(20)
  • addressIdx — INT — Foreign key → Address.idx
  • payType — VARCHAR(8)

UserAddress

  • userIdx — INT — Foreign key → User.idx — NOT NULL
  • addressIdx — INT — Foreign key → Address.idx — NOT NULL