FarmerLounge

Tables (10)

accounts (Untitled3)

  • _id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users._id — NOT NULL
  • bank (Field)
  • account_holder (Field2)
  • account_number (Field3)
  • bankbook_image (Field4)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_at (Field7)

items (Untitled8)

  • _id (Key) — Primary key — NOT NULL
  • owner_id (Key2) — Foreign key → users._id — NOT NULL
  • name (Field)
  • company (Field2)
  • images (Field4)
  • created_at (Field5)
  • updated_at (Field3)
  • deleted_at (Field6)

messages (Untitled5)

  • _id (Key) — Primary key — NOT NULL
  • sender_id (Key3) — Foreign key → users._id — NOT NULL
  • room_id (Key2) — Foreign key → rooms._id — NOT NULL
  • content (Field3)
  • files (Field4)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_at (Field)

posts (Untitled6)

  • _id (Key) — Primary key — NOT NULL
  • reported_schedule_id (Key2) — Foreign key → schedules._id — NOT NULL
  • author_id (Key3) — Foreign key → users._id — NOT NULL
  • title (Field)
  • content (Field2)
  • files (Field3)
  • type (Field4)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_at (Field7)

reviews (Untitled9)

  • _id (Key) — Primary key — NOT NULL
  • schedule_id (Key2) — Foreign key → schedules._id — NOT NULL
  • evaluator_id (Key3) — Foreign key → users._id — NOT NULL
  • receiver_id (Key4) — Foreign key → users._id — NOT NULL
  • content (Field)
  • score (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

rooms (Untitled4)

  • _id (Key) — Primary key — NOT NULL
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)
  • participants (Key2) — Foreign key → users._id — NOT NULL

schedules (Untitled7)

  • _id (Key) — Primary key — NOT NULL
  • room_id (Key2) — Foreign key → rooms._id — NOT NULL
  • showhost_id (Key3) — Foreign key → users._id — NOT NULL
  • client_id (Key4) — Foreign key → users._id — NOT NULL
  • items (Field10)
  • fee (Field)
  • broadcasted_infos (Field2)
  • scheduled_at (Field3)
  • brocasted_at (Field4)
  • completed_at (Field5)
  • reported_at (Field6)
  • created_at (Field7)
  • updated_at (Field8)
  • deleted_at (Field9)

transactions (Untitled10)

  • _id (Key) — Primary key — NOT NULL
  • target (Key3) — Foreign key → wallets._id — NOT NULL
  • source (Key2) — Foreign key → wallets._id — NOT NULL
  • schedule_id (Key4) — Foreign key → schedules._id — NOT NULL
  • amount (Field)
  • type (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

users (Untitled)

  • _id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • password (Field3)
  • salt (Field4)
  • role (Field5)
  • state (Field6)
  • created_at (Field7)
  • updated_at (Field8)
  • deleted_at (Field9)

wallets (Untitled2)

  • _id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users._id — NOT NULL
  • point (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field)