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