erd13

Tables (8)

address

  • idx — INT — Primary key — NOT NULL
  • address — VARCHAR(50)
  • detail_address — VARCHAR(50)
  • user_idx — INT
  • create_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(7)

orders

  • idx — INT — Primary key — NOT NULL
  • address — VARCHAR(100) — Foreign key → address.address
  • store_idx — INT
  • product_id — INT
  • order_price — INT
  • delivery_price — INT
  • discount_price — INT
  • total_price — INT

product

  • id — INT — Primary key — NOT NULL
  • field — VARCHAR(50)
  • price — INT
  • introduction — VARCHAR(500)
  • remain — INT
  • store_id — INT — Foreign key → store.id

review

  • id — INT — Primary key — NOT NULL
  • contents — VARCHAR(500)
  • rating — DOUBLE
  • store_id — INT — Foreign key → store.id
  • product_id — INT
  • img — TEXT
  • written_date — DATETIME
  • status — BOOL

review_backup

  • id — INT — Primary key — NOT NULL
  • contents — VARCHAR(500)
  • rating — DOUBLE
  • store_id — INT
  • product_id — INT
  • img — TEXT
  • written_date — DATETIME
  • status — BOOL

store

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • phone — VARCHAR(20)
  • address — VARCHAR(80)
  • introduction — VARCHAR(500)
  • rocket — BOOL
  • delivery_time — VARCHAR(20)

user

  • idx — INT — Primary key — NOT NULL
  • email — VARCHAR(45)
  • password — VARCHAR(255)
  • name — VARCHAR(30)
  • phone — VARCHAR(20)
  • address_idx — INT
  • pay_type — VARCHAR(8)

user_address

  • user_idx — INT — Foreign key → user.idx — NOT NULL
  • address_idx — INT — Foreign key → address.idx — NOT NULL