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)