second erd

Tables (7)

client_profile

  • user_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME
  • Field — VARCHAR(255)

contract

  • contract_id — BIGINT
  • freelancer_id — BIGINT — NOT NULL
  • client_id — BIGINT — NOT NULL
  • freelancer_sign — BLOB
  • freelancer_bank — VARCHAR(50)
  • freelancer_account — VARCHAR(100)
  • client_name — VARCHAR(50)
  • client_phone — VARCHAR(20)
  • client_sign — BLOB
  • title — VARCHAR(100)
  • start_date — DATE
  • end_date — DATE
  • amount — DECIMAL(18,2)
  • immutable_cloud_url — VARCHAR(512) — NOT NULL
  • hash — CHAR(64) — NOT NULL
  • state — ENUM('created','signed','deposit_hold','payment_confirmed','settled')
  • created_at — DATETIME
  • signed_at — DATETIME
  • updated_at — DATETIME

freelancer_profile

  • user_id — BIGINT
  • business_no — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

oauth_token

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • provider — ENUM('KAKAO','GOOGLE','NAVER','APPLE') — NOT NULL
  • access_token — VARCHAR(512) — NOT NULL
  • refresh_token — VARCHAR(512)
  • expires_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

transaction

  • transaction_id — BIGINT
  • contract_id — BIGINT — NOT NULL
  • freelancer_id — BIGINT — NOT NULL
  • client_id — BIGINT — NOT NULL
  • status — ENUM('created','signed','deposit_hold','payment_confirmed','settled')
  • contract_link — CHAR(64)
  • created_at — DATETIME
  • signed_at — DATETIME
  • deposit_hold_at — DATETIME
  • payment_confirmed_at — DATETIME
  • settled_at — DATETIME
  • client_bank — VARCHAR(50)
  • client_account — VARCHAR(100)
  • freelancer_bank — VARCHAR(50)
  • freelancer_account — VARCHAR(100)

user

  • id — BIGINT
  • provider — ENUM('KAKAO','GOOGLE','NAVER','APPLE','LOCAL') — NOT NULL
  • oauth_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('FREELANCER','CLIENT','ADMIN')
  • status — ENUM('ACTIVE','SUSPENDED','DELETED')
  • created_at — DATETIME
  • updated_at — DATETIME
  • phone — VARCHAR(20)

user_refresh_token

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • refresh_token — VARCHAR(512) — NOT NULL
  • issued_at — DATETIME
  • expires_at — DATETIME
  • is_revoked — TINYINT(1)