neo rental v.1.5
Tables (6)
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
- 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 — 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)
- created_at — timestamp
- modified_at — timestamp
- refresh_token — VARCHAR(1000)
- Field
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)