neoRental 1.6

Tables (7)

chat_message

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

chat_room

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

item_table

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

member_table

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

payment_table

  • payment_id — bigint — Primary key — NOT NULL
  • rental_id — bigint — Foreign key → rental_table.rental_id — NOT NULL
  • payment_key — varchar(255) — NOT NULL
  • order_id — varchar(255) — NOT NULL
  • amount — bigint — NOT NULL
  • status — varchar(50) — NOT NULL
  • paid_at — datetime(6)

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 — NOT NULL
  • renter_id — bigint — Foreign key → member_table.id — NOT NULL
  • total_price — int — NOT NULL
  • reject_reason — varchar(255)
  • 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)