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