test
Tables (11)
available_dates
- id — VARCHAR(36)
- item_id — VARCHAR(36) — NOT NULL
- date_available — DATE — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_item_date
categories
- id — VARCHAR(36)
- name — VARCHAR(50) — NOT NULL
- slug — VARCHAR(50) — NOT NULL
- icon — VARCHAR(255)
- item_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_slug
item_images
- id — VARCHAR(36)
- item_id — VARCHAR(36) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- sort_order — INT
- created_at — TIMESTAMP
- INDEX — idx_item
items
- id — VARCHAR(36)
- owner_id — VARCHAR(36) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- category_id — VARCHAR(36) — NOT NULL
- location — VARCHAR(100) — NOT NULL
- available — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_owner
- INDEX — idx_category
- INDEX — idx_location
notifications
- id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- message — TEXT — NOT NULL
- read — BOOLEAN
- related_id — VARCHAR(36)
- created_at — TIMESTAMP
- INDEX — idx_user
- INDEX — idx_read
payments
- id — VARCHAR(36)
- reservation_id — VARCHAR(36) — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- status — VARCHAR(20)
- transaction_id — VARCHAR(100)
- owner_id — VARCHAR(36) — NOT NULL
- renter_id — VARCHAR(36) — NOT NULL
- platform_fee — DECIMAL(10,2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- release_date — TIMESTAMP
- INDEX — idx_reservation
- INDEX — idx_status
- INDEX — idx_owner
- INDEX — idx_renter
reservations
- id — VARCHAR(36)
- item_id — VARCHAR(36) — NOT NULL
- renter_id — VARCHAR(36) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- total_price — DECIMAL(10,2) — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_item
- INDEX — idx_renter
- INDEX — idx_status
- INDEX — idx_dates
reviews
- id — VARCHAR(36)
- reservation_id — VARCHAR(36) — NOT NULL
- reviewer_id — VARCHAR(36) — NOT NULL
- reviewed_user_id — VARCHAR(36) — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- INDEX — idx_reviewed_user
users
- id — VARCHAR(36)
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50)
- phone — VARCHAR(20) — NOT NULL
- phone_verified — BOOLEAN
- avatar — VARCHAR(255)
- rating — DECIMAL(3,2)
- review_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_email
- INDEX — idx_phone
verification_codes
- id — VARCHAR(36)
- phone — VARCHAR(20) — NOT NULL
- code — VARCHAR(10) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- verified — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_phone
- INDEX — idx_expires
wishlists
- user_id — VARCHAR(36) — Primary key — NOT NULL
- item_id — VARCHAR(36) — Primary key — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_user