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)