milkit

Tables (7)

RECIPE_DAILY_RANK (Untitled)

  • RECIPE_SID (Key) — integer — Foreign key → RECIPE_MST.RECIPE_SID — NOT NULL
  • user_id (Key22) — string — Foreign key → RECIPE_MST.user_id — NOT NULL
  • RECIPE_RANK (Field) — int
  • RECIPE_CATEGORY (Field2) — stirng

RECIPE_MST

  • RECIPE_SID (Key) — integer — Primary key — NOT NULL
  • user_id (Key22) — string — Foreign key → USERS.user_id — NOT NULL
  • RECIPE_NAME (Field) — string
  • RECIPE_CONTENS (Field2) — string
  • RECIPE_COMPONENT (Field3) — string
  • created_time (Field5) — timestamp
  • recipe_category (Field6) — string

RECIPE_RECOMMENDATION (Untitled2)

  • RECIPE_SID (Key) — integer — Foreign key → RECIPE_MST.RECIPE_SID — NOT NULL
  • user_id (Key22) — string — Foreign key → RECIPE_MST.user_id — NOT NULL
  • date (Field) — timestamp

ROLE_MST (Untitled5)

  • ROLE_SID (Key) — int — Primary key — NOT NULL
  • ROLE_NAME (Field) — string

USERS

  • user_id (Key2) — string — Primary key — NOT NULL
  • user_name (Field) — string
  • user_phone (Field2) — string
  • user_password (Field3) — string
  • user_email (Field4) — string
  • status (Field5) — int
  • description (Field6) — string
  • login_fail_count (Field7) — int

USER_ROLE (Untitled4)

  • user_id (Key2) — string — Foreign key → USERS.user_id — NOT NULL
  • ROLE_SID (Key) — int — Foreign key → ROLE_MST.ROLE_SID — NOT NULL

user_logged_in (Untitled3)

  • user_id (Key2) — string — Foreign key → USERS.user_id — NOT NULL
  • logged_in_date (Field) — time_stamp