ESC
Tables (15)
admins
- id — SERIAL — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- full_name — VARCHAR(150) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
authors
- id — SERIAL — Primary key — NOT NULL
- full_name — VARCHAR(150) — NOT NULL
- title — VARCHAR(100)
- organization — VARCHAR(150)
- email — VARCHAR(150)
- bio — TEXT
- photo_url — VARCHAR(255)
- member_id — INTEGER — Foreign key → members.id
categories
- id — SERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- slug — VARCHAR(120) — NOT NULL
- module — VARCHAR(20) — NOT NULL
- description — TEXT
event_registrations
- id — SERIAL — Primary key — NOT NULL
- event_id — INTEGER — Foreign key → events.id — NOT NULL
- member_id — INTEGER — Foreign key → members.id
- full_name — VARCHAR(150) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- phone — VARCHAR(30)
- organization — VARCHAR(150)
- registered_at — TIMESTAMP — NOT NULL
- attendance_status — VARCHAR(20) — NOT NULL
event_speakers
- id — SERIAL — Primary key — NOT NULL
- event_id — INTEGER — Foreign key → events.id — NOT NULL
- full_name — VARCHAR(150) — NOT NULL
- title — VARCHAR(100)
- organization — VARCHAR(150)
- bio — TEXT
- photo_url — VARCHAR(255)
- display_order — INTEGER — NOT NULL
events
- id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- slug — VARCHAR(280) — NOT NULL
- description — TEXT
- event_type — VARCHAR(30) — NOT NULL
- category_id — INTEGER — Foreign key → categories.id
- start_datetime — TIMESTAMP — NOT NULL
- end_datetime — TIMESTAMP — NOT NULL
- is_online — BOOLEAN — NOT NULL
- location — VARCHAR(255)
- venue_address — VARCHAR(255)
- meeting_link — VARCHAR(255)
- banner_image — VARCHAR(255)
- registration_required — BOOLEAN — NOT NULL
- max_participants — INTEGER
- registration_deadline — TIMESTAMP
- status — VARCHAR(20) — NOT NULL
- created_by — INTEGER — Foreign key → admins.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
media
- id — SERIAL — Primary key — NOT NULL
- related_table — VARCHAR(20) — NOT NULL
- related_id — INTEGER — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- file_type — VARCHAR(20) — NOT NULL
- caption — VARCHAR(255)
- uploaded_at — TIMESTAMP — NOT NULL
members
- id — SERIAL — Primary key — NOT NULL
- membership_type_id — INTEGER — Foreign key → membership_types.id
- full_name — VARCHAR(150) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- phone — VARCHAR(30)
- organization — VARCHAR(150)
- position — VARCHAR(100)
- photo_url — VARCHAR(255)
- bio — TEXT
- join_date — DATE — NOT NULL
- membership_expiry — DATE
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
membership_types
- id — SERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- fee — NUMERIC(10,2) — NOT NULL
- duration_months — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
news
- id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- slug — VARCHAR(280) — NOT NULL
- summary — VARCHAR(500)
- content — TEXT — NOT NULL
- category_id — INTEGER — Foreign key → categories.id
- author_id — INTEGER — Foreign key → admins.id
- featured_image — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- published_at — TIMESTAMP
- views_count — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
news_tags
- news_id — INTEGER — Foreign key → news.id — NOT NULL
- tag_id — INTEGER — Foreign key → tags.id — NOT NULL
newsletter_subscribers
- id — SERIAL — Primary key — NOT NULL
- email — VARCHAR(150) — NOT NULL
- subscribed_at — TIMESTAMP — NOT NULL
- is_active — BOOLEAN — NOT NULL
publication_authors
- publication_id — INTEGER — Foreign key → publications.id — NOT NULL
- author_id — INTEGER — Foreign key → authors.id — NOT NULL
- author_order — INTEGER — NOT NULL
publications
- id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- slug — VARCHAR(280) — NOT NULL
- abstract — TEXT
- publication_type — VARCHAR(30) — NOT NULL
- category_id — INTEGER — Foreign key → categories.id
- file_url — VARCHAR(255) — NOT NULL
- cover_image — VARCHAR(255)
- publication_date — DATE
- volume_issue — VARCHAR(50)
- doi — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- downloads_count — INTEGER — NOT NULL
- uploaded_by — INTEGER — Foreign key → admins.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
tags
- id — SERIAL — Primary key — NOT NULL
- name — VARCHAR(60) — NOT NULL
- slug — VARCHAR(80) — NOT NULL