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