pj2

Tables (8)

Announcments (announcements)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • created_at — DATE
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL

Documents (documents)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • file_name (name) — VARCHAR(255)
  • type — VARCHAR(255)
  • file_size (size) — INT
  • created_at — DATE
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL

Members (members)

  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL
  • role — VARCHAR(20)
  • Field (approved) — BOOL
  • joined_at — DATE

Organizations (organization)

  • organization_id (id) — INT — Primary key — NOT NULL
  • org_name (name) — VARHCAR(100)
  • description — TEXT
  • image — VARCHAR(255)
  • code — VARCHAR(20)
  • created_at — DATE
  • user_id — INT — Foreign key → Users.user_id — NOT NULL

Posts (posts)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATE
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL

Schedules (schedules)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • start_time — DATE
  • end_time — DATE
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL

Users (users)

  • user_id (id) — INT — Primary key — NOT NULL
  • username — VARCHAR(20)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • mobile — VARCHAR(20)
  • image — VARCHAR(255)
  • created_at — DATE

receipts

  • id — INT — Primary key — NOT NULL
  • type — VARCHAR(10)
  • amount — INT
  • category — VARCHAR(255)
  • description — TEXT
  • transaction_date (date) — DATE
  • image — VARCHAR(255)
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • organization_id — INT — Foreign key → Organizations.organization_id — NOT NULL