특화프로젝트 ERD
테이블 (9)
asset_detail
- id — BIGSERIAL
- will_id — BIGINT — NOT NULL
- type — VARCHAR(50)
- description — TEXT
- value — DECIMAL(18,2)
- created_at — TIMESTAMP
blockchain_record
- id — BIGSERIAL
- will_id — BIGINT — NOT NULL
- tx_hash — VARCHAR(255) — NOT NULL
- block_number — BIGINT
- cid — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
lawyer
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- license_number — VARCHAR(50) — NOT NULL
- office_name — VARCHAR(100)
- created_at — TIMESTAMP
notary_log
- id — BIGSERIAL
- will_id — BIGINT — NOT NULL
- lawyer_id — BIGINT — NOT NULL
- action — VARCHAR(50)
- created_at — TIMESTAMP
user
- id — BIGSERIAL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
will
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- lawyer_id — BIGINT
- title — VARCHAR(100)
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
will_document
- id — BIGSERIAL
- will_id — BIGINT — NOT NULL
- file_url — TEXT — NOT NULL
- file_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
will_signature
- id — BIGSERIAL
- will_id — BIGINT — NOT NULL
- signer_id — BIGINT — NOT NULL
- signature_url — TEXT — NOT NULL
- created_at — TIMESTAMP
will_video
- id — BIGSERIAL
- will_id — BIGINT — NOT NULL
- file_url — TEXT — NOT NULL
- file_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP