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 (키워드)