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)