erd_최종

테이블 (9)

address

  • idx — INT — 기본 키 — NOT NULL
  • address — VARCHAR(50)
  • detail_address — VARCHAR(50)
  • user_idx — INT
  • create_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(7)

order_product

  • order_id — INT — 외래 키 → orders.idx — NOT NULL
  • product_id — INT — 외래 키 → product.id — NOT NULL
  • quantity — INT — NOT NULL

orders

  • idx — INT — 기본 키 — NOT NULL
  • address — VARCHAR(100)
  • store_idx — INT
  • product_id — INT
  • order_price — INT
  • delivery_price — INT
  • discount_price — INT
  • total_price — INT

product

  • id — INT — 기본 키 — NOT NULL
  • field — VARCHAR(50)
  • price — INT
  • introduction — VARCHAR(500)
  • remain — INT
  • store_id — INT

review

  • id — INT — 기본 키 — NOT NULL
  • contents — VARCHAR(500)
  • rating — DOUBLE
  • store_id — INT
  • product_id — INT
  • img — TEXT
  • written_date — DATETIME
  • r_status — BOOL

review_backup

  • id — INT — 기본 키 — NOT NULL
  • contents — VARCHAR(500)
  • rating — DOUBLE
  • store_id — INT
  • product_id — INT
  • img — TEXT
  • written_date — DATETIME
  • r_status — BOOL
  • deleted_date — DATETIME

store

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

user

  • idx — INT — 기본 키 — 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 — 외래 키 → user.idx — NOT NULL
  • address_idx — INT — 외래 키 → address.idx — NOT NULL