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