share service
Tables (10)
Coupon (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- discount_amount (Field2) — int
- total_quantity (Field3) — int
- remain_quantity (Field4) — int
- expires_at (Field6) — datetime
- created_at (Field5) — timestamp
- deleted_at (Field7) — timestamp
- updated_at (Field8) — timestamp
- is_active (Field9) — tinyint
Payment (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- rental_id (FK) — bigint — Foreign key → Rental.id — NOT NULL
- total_amount (Field) — int
- discount_amount (Field2) — int
- final_amount (Field3) — int
- created_at (Field4) — timestamp
PointBalance (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- balance (Field) — int
PointHistory (Untitled8)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- amount (Field) — int
- type (Field2) — enum
- created_at (Field3) — timestamp
- reason (Field4) — varchar(100)
- expired_at (Field5) — timestamp
- payment_id (Field6) — bigint
Product (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- owner_id (FK) — bigint — Foreign key → User.id — NOT NULL
- price (Field) — unsigned int
- title (Field3) — varchar(100)
- description (Field2) — varchar(100)
- product_state (Field4) — enum
- thumb_nail_image (Field5) — varchar(250)
- selected_receive_type (Field8) — int
- created_at (Field7) — timestamp
- deleted_at (Field9) — timestamp
- updated_at (Field10) — timestamp
- is_active (Field11) — tinyint
ProductLog (Untitled10)
- id (Key) — bigint — Primary key — NOT NULL
- id (FK) — bigint — Foreign key → Product.id — NOT NULL
- field_name (Field) — varchar(50)
- before_value (Field2) — varchar(255)
- after_value (Field3) — varchar(255)
- changed_at (Field4) — timestamp
Rental (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- item_id (FK) — bigint — Foreign key → Product.id — NOT NULL
- renter_id (FK3) — bigint — Foreign key → User.id — NOT NULL
- start_date_at (Field) — timestamp
- end_date_at (Field2) — timestamp
- selected_receive_type (Field3) — int
- status (Field4) — enum
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- deleted_at (Field7) — timestamp
- is_active (Field8) — tinyint
RentalLog (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- rental_id (FK) — bigint — Foreign key → Rental.id — NOT NULL
- prev_status (Field) — varchar(20)
- after_status (Field2) — varchar(20)
- changed_at (Field3) — timestamp
User (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- email (Field5) — varchar(50)
- phone_number (Field) — encrypted
- name (Field2) — varchar(20)
- latitude (Field3) — decimal(10,8)
- longitude (Field9) — decimal(11,8)
- created_at (Field4) — timestamp
- deleted_at (Field7) — timestamp
- updated_at (Field6) — timestamp
- is_active (Field8) — tinyint
UserCoupon (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- Coupon_id (FK2) — bigint — Foreign key → Coupon.id — NOT NULL
- status (Field) — enum
- issued_at (Field2) — timestamp