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