contacto_project_nofk

Tables (11)

chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — NOT NULL — logical FK -> chat_rooms.id
  • sender_id — BIGINT — NOT NULL — logical FK -> users.id
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_chat_messages_room_created
  • INDEX — idx_chat_messages_sender

chat_room_members

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — NOT NULL — logical FK -> chat_rooms.id
  • user_id — BIGINT — NOT NULL — logical FK -> users.id
  • role — VARCHAR(10) — NOT NULL — OWNER|MEMBER
  • status — VARCHAR(10) — NOT NULL — ACTIVE|LEFT|REMOVED
  • joined_at — DATETIME — NOT NULL
  • left_at — DATETIME
  • INDEX — idx_crm_user
  • INDEX — idx_crm_room_status

chat_rooms

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — MULTI room can reference project; SINGLE(DM) may be NULL
  • type — VARCHAR(10) — NOT NULL — SINGLE|MULTI
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_chat_rooms_project
  • INDEX — idx_chat_rooms_type

project_images

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL — logical FK -> projects.id
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_project_images_project

project_participants

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL — logical FK -> projects.id
  • user_id — BIGINT — NOT NULL — logical FK -> users.id
  • status — VARCHAR(20) — NOT NULL — REQUESTED|ACCEPTED|REJECTED|BANNED
  • rejected_at — DATETIME
  • banned_at — DATETIME
  • deleted_at — DATETIME — soft delete timestamp (leave)
  • active_key — TINYINT — 1 for active row; set NULL when soft-deleted
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_pp_project_status
  • INDEX — idx_pp_user_status
  • INDEX — idx_pp_project_user
  • INDEX — idx_pp_deleted_at

project_purposes

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL — logical FK -> projects.id
  • purpose_id — BIGINT — NOT NULL — logical FK -> purposes.id
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_project_purposes_project
  • INDEX — idx_project_purposes_purpose

project_talents

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL — logical FK -> projects.id
  • talent_id — BIGINT — NOT NULL — logical FK -> talents.id
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_project_talents_project
  • INDEX — idx_project_talents_talent

projects

  • id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — NOT NULL — logical FK -> users.id
  • status — VARCHAR(20) — NOT NULL — ACTIVE|CLOSED|DELETED
  • title — VARCHAR(255) — NOT NULL
  • overview — TEXT
  • project_type_code — VARCHAR(50)
  • experience_code — VARCHAR(50)
  • location_text — VARCHAR(255)
  • max_participants — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_projects_owner
  • INDEX — idx_projects_status_created

purposes

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_purposes_active_sort

talents

  • id — BIGINT — Primary key — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • parent_name — VARCHAR(100)
  • name — VARCHAR(100) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_talents_category
  • INDEX — idx_talents_active_sort
  • INDEX — idx_talents_name

users

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_users_username