AIML

Tables (10)

auth_logs

  • id — BIGINT
  • device_id (user_id) — BIGINT
  • user_id (payment_method_id) — BIGINT
  • is_success (amount) — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

devices

  • id — BIGINT — Primary key
  • institution_id — BIGINT — Foreign key → institutions.id
  • firmware_version — VARCHAR(100)
  • location — VARCHAR(255)
  • status — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

institutions

  • id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

payment_histories

  • id — BIGINT
  • user_id — BIGINT
  • payment_method_id — BIGINT
  • amount — DECIMAL(10, 2) — NOT NULL
  • created_at — DATETIME — NOT NULL

payment_methods

  • id — BIGINT — Primary key
  • user_id (id2) — BIGINT — Foreign key → users.id
  • method_type — VARCHAR(50) — NOT NULL
  • pg_billing_key — VARCHAR(255) — NOT NULL
  • pg_customer_key — VARCHAR(255) — NOT NULL
  • card_nickname — VARCHAR(100)
  • last_4_digits — CHAR(4)
  • created_at — DATETIME — NOT NULL

reports

  • id — BIGINT — Primary key
  • user_id (id2) — BIGINT — Foreign key → users.id
  • auth_log_id — BIGINT
  • report_type — VARCHAR(100) — NOT NULL
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

roles

  • id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL

user_institution_roles

  • id — BIGINT — Primary key
  • role_id (id2) — BIGINT — Foreign key → roles.id
  • user_id (id3) — BIGINT — Foreign key → users.id
  • institution_id — BIGINT
  • created_at — DATETIME — NOT NULL

user_institutions

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • institution_id — BIGINT — Foreign key → institutions.id
  • local_id (student_id) — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20)
  • created_at — DATETIME — NOT NULL