borolo

Tables (9)

Deposit

  • deposit_id — NUMBER
  • amount — NUMBER — NOT NULL
  • deposit_status — VARCHAR2(50)
  • rental_id — NUMBER — NOT NULL

Favorite

  • user_id — NUMBER — Primary key — NOT NULL
  • item_id — NUMBER — Primary key — NOT NULL
  • created_at — TIMESTAMP

Item

  • item_id — NUMBER
  • title — VARCHAR2(100) — NOT NULL
  • description — VARCHAR2(255)
  • quantity — NUMBER — NOT NULL
  • price_per_day — NUMBER — NOT NULL
  • deposit_amount — NUMBER — NOT NULL
  • image_url — VARCHAR2(255)
  • location — VARCHAR2(100)
  • item_status — VARCHAR2(20)
  • create_time — TIMESTAMP
  • update_time — TIMESTAMP
  • user_id — NUMBER — NOT NULL
  • category_id — NUMBER — NOT NULL

ItemCategory

  • category_id — NUMBER
  • category_name — VARCHAR2(50) — NOT NULL
  • sort — VARCHAR2(50)

Rental

  • rental_id — NUMBER
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • meeting_time — TIMESTAMP
  • meeting_location — VARCHAR2(100)
  • rental_status — VARCHAR2(20)
  • is_approved — CHAR(1)
  • is_completed — CHAR(1)
  • item_id — NUMBER — NOT NULL
  • user_id — NUMBER — NOT NULL

Report

  • report_id — NUMBER
  • reporter_id — NUMBER — NOT NULL
  • target_user_id — NUMBER — NOT NULL
  • rental_id — NUMBER — NOT NULL
  • reason — CLOB — NOT NULL
  • created_at — TIMESTAMP

Review

  • review_id — NUMBER
  • content — CLOB — NOT NULL
  • rating — NUMBER — NOT NULL
  • created_at — TIMESTAMP
  • rental_id — NUMBER — NOT NULL
  • user_write_id — NUMBER — NOT NULL
  • user_target_id — NUMBER — NOT NULL

User

  • user_id — NUMBER
  • password — VARCHAR2(255) — NOT NULL
  • real_name — VARCHAR2(20) — NOT NULL
  • nick_name — VARCHAR2(20) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • birth_date — DATE
  • rating — FLOAT
  • create_time — TIMESTAMP
  • is_deleted — CHAR(1)
  • Field

UserLocation

  • user_id — NUMBER
  • lat — NUMBER(10,7)
  • lng — NUMBER(10,7)
  • district — VARCHAR2(50)
  • is_manual — CHAR(1)
  • update_time — TIMESTAMP