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)