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