pillgood

Tables (28)

answers

  • inquiry_no — INT
  • answer_content — TEXT
  • answer_date — DATETIME

billings

  • billing_key — VARCHAR(50)
  • member_unique_id — CHAR(32)

carts

  • cart_no — INT
  • member_unique_id — CHAR(32)
  • product_id — INT
  • product_quantity — INT

coupons

  • coupon_id — INT
  • coupon_name — VARCHAR(100) — NOT NULL
  • discount_amount — INT
  • discount_description — VARCHAR(255)
  • coupon_status — VARCHAR(50)
  • validity_period — INT

deficiencies

  • deficiency_id — INT
  • deficiency_name — VARCHAR(255)

deficiency_nutrients

  • deficiency_nutrient_id — INT
  • deficiency_id — INT
  • nutrient_id — INT

detailed_questions

  • detailed_question_id — INT
  • deficiency_id — INT
  • question_content — TEXT

efficiencies

  • efficiency_id — INT
  • efficiency_name — VARCHAR(255)

inquiries

  • inquiry_no — INT
  • member_unique_id — CHAR(32)
  • inquiry_date — DATETIME
  • inquiry_status — VARCHAR(50)
  • inquiry_type — VARCHAR(50)
  • inquiry_title — VARCHAR(255)
  • inquiry_content — TEXT

members

  • member_unique_id — CHAR(32)
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • age — INT — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • phone_number — VARCHAR(15) — NOT NULL
  • registration_date — DATETIME
  • subscription_status — BOOLEAN
  • modified_date — DATETIME
  • member_level — VARCHAR(10)
  • coupon_issued — BOOLEAN
  • provider — VARCHAR(50)
  • social_id — VARCHAR(50)

notices

  • notice_no — INT
  • notice_title — VARCHAR(255) — NOT NULL
  • notice_content — TEXT

nutrient_efficiencies

  • nutrient_efficiency_id — INT
  • nutrient_id — INT
  • efficiency_id — INT

nutrients

  • nutrient_id — INT
  • nutrient_name — VARCHAR(255)
  • description — TEXT

order_details

  • order_detail_no — INT
  • order_no — VARCHAR(50)
  • product_id — INT
  • quantity — INT
  • amount — INT

orders

  • order_no — VARCHAR(50)
  • total_amount — INT
  • order_request — VARCHAR(255)
  • order_date — DATETIME
  • recipient — VARCHAR(100)
  • postal_code — VARCHAR(10)
  • address — VARCHAR(255)
  • detailed_address — VARCHAR(255)
  • phone_number — VARCHAR(15)
  • member_unique_id — CHAR(32)
  • owned_coupon_id — INT
  • order_status — VARCHAR(50)
  • subscription_status — BOOLEAN
  • points_to_use — INT

owned_coupons

  • owned_coupon_id — INT
  • coupon_id — INT
  • member_unique_id — CHAR(32)
  • coupon_used — BOOLEAN
  • issued_date — DATETIME
  • expiry_date — DATETIME

payments

  • payment_no — VARCHAR(50)
  • order_no — VARCHAR(50) — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • method — VARCHAR(20)
  • payment_date — TIMESTAMP
  • detail — TEXT
  • refund_status — VARCHAR(20)
  • refund_date — TIMESTAMP
  • subscription_status — VARCHAR(50)

point_details

  • point_detail_id — INT
  • member_unique_id — CHAR(32)
  • point_status_code — VARCHAR(50)
  • points — INT
  • detail_history_id — INT
  • point_id — INT
  • transaction_date — DATETIME
  • expiry_date — DATETIME

points

  • point_id — INT
  • member_unique_id — CHAR(32)
  • point_master_id — VARCHAR(50)
  • point_status_code — VARCHAR(50)
  • points — INT
  • transaction_date — DATETIME
  • expiry_date — DATETIME
  • reference_id — VARCHAR(50)

products

  • product_id — INT
  • nutrient_id — INT
  • product_name — VARCHAR(255)
  • product_image — VARCHAR(255)
  • price — INT
  • stock — INT
  • product_registration_date — DATETIME
  • target — VARCHAR(255)
  • active — BOOLEAN

refunds

  • refund_id — INT
  • refund_request_date — DATETIME
  • refund_complete_date — DATETIME
  • total_refund_amount — INT
  • refund_method — VARCHAR(50)
  • refund_bank — VARCHAR(50)
  • refund_status — VARCHAR(50)
  • order_no — VARCHAR(50)

returns

  • return_id — INT — NOT NULL
  • request_date — DATETIME
  • received_date — DATETIME
  • processed_date — DATETIME
  • cancelled_date — DATETIME
  • order_no — VARCHAR(50) — NOT NULL
  • return_status — VARCHAR(50)

reviews

  • review_id — INT
  • member_unique_id — CHAR(32)
  • order_detail_no — INT
  • review_date — DATETIME
  • review_content — TEXT
  • rating — INT
  • review_image — VARCHAR(255)
  • coupon_issued — BOOLEAN

shipping_addresses

  • shipping_addr_id — INT
  • member_unique_id — CHAR(32)
  • shipping_name — VARCHAR(50)
  • postal_code — VARCHAR(10)
  • address — VARCHAR(255)
  • detailed_address — VARCHAR(255)

subscriptions

  • subscription_id — INT
  • member_unique_id — CHAR(32)
  • start_date — DATETIME
  • end_date — DATETIME
  • subscription_status — VARCHAR(50)
  • payment_no — VARCHAR(50)

survey_answers

  • answer_id — INT
  • question_id — INT
  • answer_content — TEXT
  • deficiency_id — INT

survey_questions

  • question_id — INT
  • question_content — TEXT
  • parent_question_id — INT

surveys

  • survey_no — INT
  • member_unique_id — CHAR(32)
  • name — VARCHAR(255)
  • age — INT
  • gender — VARCHAR(10)
  • height — INT
  • weight — INT
  • deficiency_id1 — INT
  • deficiency_id2 — INT
  • deficiency_id3 — INT
  • survey_date — DATETIME
  • recommended_products — VARCHAR(255)
  • keywords — VARCHAR(255)