service

Tables (8)

applicant

  • applicant_id — bigint — Foreign key → orders.applicant_id — NOT NULL
  • city — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)
  • email — varchar(255)
  • id_info — varchar(255)
  • name — varchar(255)
  • phone_number — varchar(255)
  • want_number — varchar(4)
  • welfare — varchar(255)

delivery

  • delivery_id — bigint — Foreign key → orders.delivery_id — NOT NULL
  • city — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)
  • request — varchar(255)

discount_ids

  • discountids_id — bigint — Primary key — NOT NULL
  • discount_id — bigint
  • productinfo_id — bigint — Foreign key → product_info.productinfo_id

order_terms

  • orderterms_id — bigint — Primary key — NOT NULL
  • order_id — bigint
  • terms_id — bigint

orders

  • order_id — bigint — Foreign key → order_terms.order_id — NOT NULL
  • apply_type — varchar(255)
  • discount_type — varchar(255)
  • installment_period — integer
  • applicant_id — bigint
  • delivery_id — bigint
  • payment_id — bigint
  • product_info_id — bigint

payment

  • payment_id — bigint — Foreign key → orders.payment_id — NOT NULL
  • account_number — varchar(20)
  • bank — varchar(255)
  • credit_card_number — varchar(16)
  • pay_method — varchar(255)
  • validity — varchar(4)

product_info

  • productinfo_id — bigint — Foreign key → orders.product_info_id — NOT NULL
  • insurance_id — bigint
  • phone_id — bigint
  • plan_id — bigint
  • total_monthly_payment — integer

terms

  • terms_id — bigint — Foreign key → order_terms.terms_id — NOT NULL
  • explanation — TEXT
  • name — varchar(255)
  • term_type — varchar(255)