contacto_project

Tables (11)

chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • id (id2) — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → users.id — NOT NULL

chat_room_members

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • joined_at — DATETIME — NOT NULL
  • left_at — DATETIME
  • id (id2) — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → users.id — NOT NULL

chat_rooms

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT
  • type — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • id (id2) — BIGINT — Foreign key → projects.id — NOT NULL

project_images

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • id (id2) — BIGINT — Foreign key → projects.id — NOT NULL

project_participants

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • rejected_at — DATETIME
  • banned_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • id (id2) — BIGINT — Foreign key → projects.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → users.id — NOT NULL

project_purposes

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL
  • purpose_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • id (id2) — BIGINT — Foreign key → projects.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → purposes.id — NOT NULL

project_talents

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL
  • talent_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • id (id2) — BIGINT — Foreign key → projects.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → talents.id — NOT NULL

projects

  • id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • 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
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL

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

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

users

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