Meridian

Tables (9)

consensus_summaries

  • id — BIGSERIAL — Primary key — NOT NULL
  • proposal_id — BIGINT — Foreign key → proposals.id — NOT NULL
  • consensus_status — VARCHAR(20) — NOT NULL
  • key_issues — TEXT
  • cultural_analysis — TEXT
  • hidden_opposition — TEXT
  • recommended_actions — TEXT
  • created_at — TIMESTAMP — NOT NULL

culture_analyses

  • id — BIGSERIAL — Primary key — NOT NULL
  • proposal_id — BIGINT — Foreign key → proposals.id — NOT NULL
  • original_text — TEXT — NOT NULL
  • risk_level — VARCHAR(20) — NOT NULL
  • interpretation — TEXT
  • flagged_phrase — TEXT
  • suggested_rewrite — TEXT
  • applied — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notifications

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • proposal_id — BIGINT — Foreign key → proposals.id
  • type — VARCHAR(30) — NOT NULL
  • message — VARCHAR(300) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

opinions

  • id — BIGSERIAL — Primary key — NOT NULL
  • proposal_id — BIGINT — Foreign key → proposals.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • stance — VARCHAR(20) — NOT NULL
  • comment — TEXT
  • attachment_url — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

proposal_target_cultures

  • id — BIGSERIAL — Primary key — NOT NULL
  • proposal_id — BIGINT — Foreign key → proposals.id — NOT NULL
  • culture_name — VARCHAR(50) — NOT NULL

proposals

  • id — BIGSERIAL — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • target_team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • deadline — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

team_members

  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(30)
  • joined_at — TIMESTAMP — NOT NULL

teams

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • country — VARCHAR(100)
  • culture_tag — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • country — VARCHAR(100)
  • timezone — VARCHAR(50)
  • culture_tag — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL