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)