Enssurify

Tables (7)

bank (은행)

  • id (Key) — long — Primary key — NOT NULL
  • name (이름) — string

clerk (행원)

  • id (Key) — long — Primary key — NOT NULL
  • bank_id (은행 id) — long — Foreign key → bank.id — NOT NULL
  • name (이름) — string
  • image_url (프로필 사진) — string
  • username (아이디) — string
  • password (비밀번호) — string

client (고객)

  • id (Key) — long — Primary key — NOT NULL
  • bank_id (은행 id) — long — Foreign key → bank.id — NOT NULL
  • name (이름) — string
  • email (메일) — string
  • sex (성별) — boolean
  • age (나이) — int
  • job (직업) — string

contract (계약)

  • id (Key) — long — Primary key — NOT NULL
  • contract_document_id (계약서 id) — long — Foreign key → contract_document.id — NOT NULL
  • clerk_id (행원id) — long — Foreign key → clerk.id — NOT NULL
  • client_id (고객 id) — long — Foreign key → client.id — NOT NULL

contract_details (계약 세부 사항)

  • id (Key) — long — Primary key — NOT NULL
  • contract_id (계약 id) — long — Foreign key → contract.id — NOT NULL
  • action (동작) — enum
  • x-axis (x축) — int
  • y-axis (y축) — int
  • signature (서명) — string

contract_document (계약서)

  • id (Key) — long — Primary key — NOT NULL
  • bank_id (은행 id) — long — Foreign key → bank.id — NOT NULL
  • name (계약명) — string
  • pdf_url (계약서 서식) — string

contract_keyword (계약 키워드)

  • id (Key) — long — Primary key — NOT NULL
  • contract_id (계약 id) — long — Foreign key → contract_document.id — NOT NULL
  • keyword (키워드)