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