BCSD_INTERNAL

Tables (3)

dues

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint
  • is_delete — boolean
  • date — timestamp(6)
  • memo — varchar(255)
  • status — varchar(255)

member

  • id — bigint — Primary key — NOT NULL
  • authority — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • student_number — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • is_authorized — boolean
  • updated_at — timestamp
  • created_at — timestamp
  • is_delete — boolean

payment

  • id — bigint — Primary key — NOT NULL
  • amount — bigint
  • date — timestamp(6)
  • remain_money — bigint
  • account_holder — varchar(255)
  • description — varchar(255)
  • memo — varchar(255)
  • is_delete — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • Field