Talade
Tables (7)
Category (Untitled3)
- category_id (Key) — PK, INT, AUTO_INCREMENT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
Chat (Untitled7)
- chat_id (Key) — INT, AUTO_INCREMENT — Primary key — NOT NULL
- matching_id (Field) — INT
- sender_id (Field2) — INT
- receiver_id (Field3) — INT
- message (Field4) — TEXT
- is_read (Field5) — BOOLEAN
- created_at (Field6) — DATETIME
Exchange (Untitled5)
- exchange_id (Key) — INT, AUTO_INCREMENT — Primary key — NOT NULL
- matching_id (Field) — INT
- requester_id (Field2) — INT
- receiver_id (Field3) — INT
- talent_id (Field4) — INT
- status (Field5) — ENUM('IN_PROGRESS','COMPLETED','CANCELLED')
- created_at (Field6) — DATETIME
- completed_at (Field7) — DATETIME
Matching (Untitled6)
- matching_id (Key) — PK, INT, AUTO_INCREMENT — Primary key — NOT NULL
- requester_id (Field) — INT
- receiver_id (Field2) — INT
- talent_id (Field3) — INT
- status (Field4) — ENUM('PENDING', 'ACCEPTED', 'REJECTED')
- created_at (Field5) — DATETIME
Review (Untitled4)
- review_id (Key) — INT, AUTO_INCREMENT — Primary key — NOT NULL
- reviewer_id (Field) — INT
- reviewee_id (Field2) — INT
- talent_id (Field3) — INT
- rating (Field4) — DECIMAL(3,2)
- content (Field5) — TEXT
- created_at (Field6) — DATETIME
Talent (Untitled2)
- talent_id (Key) — INT, AUTO_INCREMENT — Primary key — NOT NULL
- user_id (Field12) — INT — NOT NULL
- category (Field) — INT
- title (Field2) — VARCHAR(255)
- description (Field3) — TEXT
- price (Field4) — INT
- location (Field5) — VARCHAR(255)
- is_online (Field6) — BOOLEAN
- exchange_type (Field7) — ENUM('EXCHANGE', 'PAID', 'BOTH')
- status (Field8) — ENUM('AVAILABLE', 'CLOSED')
- trade_count (Field9) — INT
- view_count (Field10) — INT
- created_at (Field11) — DATETIME
User (Untitled)
- user_id (Key) — INT, AUTO_INCREMENT — Primary key — NOT NULL
- talent_id (Key2) — INT, AUTO_INCREMENT — Foreign key → Talent.talent_id — NOT NULL
- email (Field) — VARCHAR(255)
- password (Field2) — VARCHAR(255)
- nickname (Field3) — VARCHAR(50)
- phone (Field4) — VARCHAR(20)
- avg_rating (Field5) — DECIMAL(3,2)
- profile_image (Field6) — VARCHAR(255)
- bio (Field7) — TEXT
- created_at (Field8) — DATETIME
- role (Field9) — VARCHAR(20)
- deleted_at (Field10) — DATETIME
- re_register_available_at (Field11) — DATETIME