neorental1.2

Tables (6)

chat_message

  • message_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → chat_room.room_id
  • sender_id — bigint
  • sender_name — varchar(255)
  • message — text
  • send_date — datetime(6)

chat_room

  • room_id — bigint — Primary key — NOT NULL
  • item_id — bigint — Foreign key → item_table.item_id
  • buyer_id — bigint — Foreign key → member_table.id
  • seller_id — bigint — Foreign key → member_table.id
  • created_at — datetime(6)

item_table

  • item_id — bigint — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • price — int — NOT NULL
  • location — varchar(100)
  • item_image_url — text
  • item_status — varchar(255)
  • member_id — bigint — Foreign key → member_table.id
  • created_at — datetime(6)
  • modified_at — datetime(6)

member_table

  • id — bigint — Primary key — NOT NULL
  • email — varchar(255)
  • password — varchar(255)
  • name — varchar(255)
  • phone — varchar(255)
  • address — varchar(255)
  • created_at — timestamp
  • modified_at — timestamp

rental_table

  • rental_id — bigint — Primary key — NOT NULL
  • status — varchar(255) — NOT NULL
  • start_date — datetime(6) — NOT NULL
  • end_date — datetime(6) — NOT NULL
  • item_id — bigint — Foreign key → item_table.item_id
  • renter_id — bigint — Foreign key → member_table.id
  • created_at — datetime(6)
  • modified_at — datetime(6)

review_table

  • review_id — bigint — Primary key — NOT NULL
  • rental_id — bigint — Foreign key → rental_table.rental_id — NOT NULL
  • item_id — bigint — Foreign key → item_table.item_id — NOT NULL
  • reviewer_id — bigint — Foreign key → member_table.id — NOT NULL
  • rating — int — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime(6)