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