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