특화프로젝트 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