FDS프로젝트
테이블 (14)
CarClaim (자동차보험(청구서))
- mem_carnumber (Key) — varchar(40) — 기본 키 — NOT NULL
- mem_id (Key2) — varchar(40) — 외래 키 → CarMembers.mem_id — NOT NULL
- claim_number (Field) — varchar(40)
- claim_name (Field2) — varchar(50)
- claim_car (Field3) — varchar(40)
- claim_tel (Field4) — varchar(13)
- claim_licensenumber (Field5) — varchar(40)
- claim_licensetype (Field6) — varchar(20)
- claim_accidentdate (Field7) — date
- claim_location (Field8) — varchar(255)
- claim_situation (Field9) — varchar(255)
- claim_count (Field10) — number
- claim_hospital (Field11) — varchar(50)
- claim_signname (Field12) — varchar(50)
- claim_addr (Field13) — varchar(255)
CarMembers (자동차보험(청구자))
- mem_id (Key) — varchar(40) — 기본 키 — NOT NULL
- mem_name (Field) — varchar(50)
- mem_birth (Field2) — date
- mem_car (Field3) — varchar(50)
- mem_carnumber (Field4) — varchar(20)
- mem_addr (Field5) — varchar(255)
- mem_addrdetail (Field6) — varchar(255)
- mem_postcode (Field7) — number
- mem_start_date (Field8) — date
- mem_end_date (Field9) — date
- mem_phone (Field10) — varchar(13)
- mem_email (Field11) — varchar(100)
- mem_licensenumber (Field12) — varchar(40)
- mem_licensetype (Field13) — varchar(20)
Card (해외카드결제(카드))
- card_id (Key) — varchar(40) — 기본 키 — NOT NULL
- customer_id (Key2) — varchar(40) — 외래 키 → Customers.customer_id — NOT NULL
- card_num (Field) — varchar(20)
- expiry_date (Field2) — date
- issue_country (Field3) — varchar(50)
- error_count (Field4) — number
Country (해외카드결제(국가))
- country_id (Key) — varchar(40) — 기본 키 — NOT NULL
- country_code (Field) — varchar(2)
- country_name (Field2) — varchar(50)
- ip_start_num (Field3) — number
- ip_start_num (Field4) — number
Customers (해외카드결제(고객))
- customer_id (Key) — varchar(40) — 기본 키 — NOT NULL
- customer_name (Field) — varchar(50)
- customer_email (Field2) — varchar(100)
- customer_phone (Field3) — varchar(13)
- customer_addr (Field4) — varchar(255)
- customer_addr_detail (Field5) — varchar(255)
- customer_post (Field6) — number
- customer_country (Field7) — varchar(2)
Death_Claim (사망보험(청구서))
- claim_num (Key) — varchar(40) — 기본 키 — NOT NULL
- ins_id (Key2) — varchar(40) — 외래 키 → Insured.ins_id — NOT NULL
- CLAIM_CONTENT (Field) — varchar(2000)
- CLAIM_NAME (Field2) — varchar(50)
- CLAIM_BIRTH (Field3) — date
- CLAIM_ADDR (Field4) — varchar(255)
- CLAIM_ADDR_DETAIL (Field5) — varchar(255)
- CLAIM_POST (Field6) — number
- CLAIM_EMAIL (Field7) — varchar(100)
- CAUSE_OF_DEATH (Field8) — varchar(20)
- DATE_OF_DEATH (Field9) — date
- PLACE_OF_DEATH (Field10) — varchar(20)
- TYPE_OF_DEATH (Field11) — varchar(50)
- BENEFICIARY_ACCOUNT (Field12) — varchar(40)
- CLAIM_DATE (Field13) — date
IP_Agree (해외카드결제(IP등록))
- customer_id (Key) — varchar(40) — 외래 키 → Customers.customer_id — NOT NULL
- ip_address (Field) — number
- agree_date (Field2) — date
IP_Block (해외카드결제(IP차단))
- customer_id (Key) — varchar(40) — 외래 키 → Customers.customer_id — NOT NULL
- ip_address (Field) — number
- block_date (Field2) — date
Insured (사망보험(피보험자))
- ins_id (Key) — varchar(40) — 기본 키 — NOT NULL
- INS_NAME (Field) — varchar(50)
- INS_BIRTH (Field2) — date
- INS_ADDR (Field3) — varchar(255)
- INS_ADDR_DETAIL (Field4) — varchar(255)
- INS_POST (Field5) — number
- INS_PHONE (Field6) — varchar(13)
- INS_EMAIL (Field7) — varchar(100)
- INS_CASE_HISTORY (Field8) — varchar(100)
- INS_BENEFICIARY (Field9) — varchar(50)
- INS_PRIVITY (Field10) — varchar(20)
- INS_BEN_PHONE (Field11) — varchar(13)
- INS_CONTRACT_DATE (Field12) — date
Trading_halt (해외카드결제(카드정지))
- card_id (Key) — varchar(40) — 외래 키 → Card.card_id — NOT NULL
- customer_id (Key2) — varchar(40) — 외래 키 → Card.customer_id — NOT NULL
- halt_date (Field) — date
accmembers (계좌이체(고객))
- accmem_num (Key) — varchar(40) — 기본 키 — NOT NULL
- accmem_name (Field) — varchar(50)
- accmem_addr (Field2) — varchar(255)
- accmem_detail (Field3) — varchar(255)
- accmem_post (Field4) — number
- accmem_tel (Field5) — varchar(13)
- accmem_birth (Field6) — date
account (계좌이체(고객계좌))
- account_num (Key) — varchar(40) — 기본 키 — NOT NULL
- accmem_num (Key2) — varchar(40) — 외래 키 → accmembers.accmem_num — NOT NULL
- account_date (Field) — date
purchase (해외카드결제(결제))
- purchase_id (Key) — varchar(40) — 기본 키 — NOT NULL
- card_id (Key2) — varchar(40) — 외래 키 → Card.card_id — NOT NULL
- customer_id (Key22) — varchar(40) — 외래 키 → Card.customer_id — NOT NULL
- country_id (Key3) — varchar(40) — 외래 키 → Country.country_id — NOT NULL
- purchase_price (Field) — number
- purchase_date (Field2) — date
- purchase_status (Field3) — varchar(20)
transferInfo (계좌이체(입출금))
- transfer_num (Key) — varchar(40) — 기본 키 — NOT NULL
- account_num (Key2) — varchar(40) — 외래 키 → account.account_num — NOT NULL
- accmem_num (Key22) — varchar(40) — 외래 키 → account.accmem_num — NOT NULL
- income_price (Field) — number
- income_date (Field2) — date
- outcome_price (Field3) — number
- outcome_date (Field4) — date
- transfer_content (Field5) — varchar(2000)