LiveKlass

Tables (7)

cart_add_details

  • event_id — UUID — Foreign key → master_event_logs.event_id — NOT NULL
  • lecture_id — INT — NOT NULL

master_event_logs

  • event_id — UUID — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • creator_id — INT — Foreign key → users.user_id — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

page_view_details

  • event_id — UUID — Foreign key → master_event_logs.event_id — NOT NULL
  • lecture_id — INT — NOT NULL
  • referrer — VARCHAR(100) — NOT NULL

payment_details

  • event_id — UUID — Foreign key → master_event_logs.event_id — NOT NULL
  • order_id — VARCHAR(100) — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • error_code — VARCHAR(50)

payment_tasks

  • task_id — BIGSERIAL — Primary key — NOT NULL
  • order_id — VARCHAR(100) — Foreign key → payment_details.order_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • user_id — UUID — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL

video_buffering_details

  • event_id — UUID — Foreign key → master_event_logs.event_id — NOT NULL
  • lecture_id — INT — NOT NULL
  • buffering_duration — INT — NOT NULL
  • user_agent — VARCHAR(255) — NOT NULL