Uwellnow Mobile App(Order)_v.RecipeRecommendation
Tables (7)
members
- id — SERIAL
- phone — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth — VARCHAR(20)
- gender — VARCHAR(10)
- payment_date — TIMESTAMPTZ
- member_type — VARCHAR(20)
- member_code — VARCHAR(100)
- registrant_name — VARCHAR(50)
- registrant_store — VARCHAR(100)
- created_at — TIMESTAMPTZ
memberships
- id — SERIAL
- barcode — VARCHAR(100) — NOT NULL
- membership_name — VARCHAR(100)
- remain_count — INTEGER
- total_count — INTEGER
- created_at — TIMESTAMPTZ
- expired_at — TIMESTAMPTZ
- owner_id — INTEGER
orders
- id — SERIAL
- product_id — INTEGER
- product_name — VARCHAR(100)
- product_time — VARCHAR(50)
- product_count — INTEGER
- store_name — VARCHAR(100)
- user_id — INTEGER
- user_name — VARCHAR(50)
- user_birth — VARCHAR(20)
- user_gender — VARCHAR(10)
- membership_id — INTEGER
- barcode — VARCHAR(100)
- remain_count_after_purchase — INTEGER
- total_count_at_purchase — INTEGER
- order_time — TIMESTAMPTZ
products
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
- name_eng — VARCHAR(100) — NOT NULL
- timing — VARCHAR(50)
- description — TEXT
- description_eng — TEXT
- nutrition_info — TEXT
- nutrition_info_eng — TEXT
- company_image_path — VARCHAR(255)
- product_image_path — VARCHAR(255)
- one_capacity — INTEGER
- recipe_slots — JSONB
- type — VARCHAR(20)
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
recipe_components
- id — SERIAL
- recipe_id — INTEGER — NOT NULL
- product_id — INTEGER — NOT NULL
- role — recipe_role — NOT NULL
- amount_seconds — NUMERIC(6,2) — NOT NULL
- created_at — TIMESTAMPTZ
recipes
- id — SERIAL
- recipe_code — VARCHAR(100) — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- water_amount — INTEGER
- is_active — BOOLEAN
- membership_id — INTEGER
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
user_recipes
- id — SERIAL
- member_id — INTEGER
- recipe_id — INTEGER
- qr_token — VARCHAR(128) — NOT NULL
- expires_at — TIMESTAMPTZ
- ai_score — NUMERIC(5,2)
- ai_reason — TEXT
- created_at — TIMESTAMPTZ