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