VEGUN_DIET_MANAGER
Tables (11)
COMMON_GROUP
- Key (GROUP_NAME) — TEXT — Primary key — NOT NULL
- Field (DESCRIPTION) — TEXT
DIET_ITEM
- DIET_ITEM_ID — UUID — Primary key — NOT NULL
- DIET_TABLE_ID — UUID
- FOOD_NAME — TEXT
- FOOD_IMAGE — TEXT
- SERVING_SIZE — INTEGER
- CALORIE — INTEGER
- CARBOHYDRATE — INTEGER
- PROTEIN — INTEGER
- FAT — INTEGER
- IRON — INTEGER
- CALCIUM — INTEGER
- DIETARY_FIBER (DIETARY_FIEBER) — INTEGER
DIET_TABLE
- DIET_TABLE_ID — UUID — Primary key — NOT NULL
- MEMBER_ID (USER_ID) — UUID
- DIET_DATE — TIMESTAMPTZ
- DIET_TIME — INTEGER
- CREAT_DATE (CREATE_DATE) — TIMESTAMPTZ
- UPDATE_DATE — TIMESTAMPTZ
MEMBER
- ID — UUID — Primary key — NOT NULL
- NICKNAME — TEXT
- MEMBER_STATE (USER_STATE) — INTEGER
- DIET_TYPE — INTEGER
- DIET_GOAL — INTEGER
- PROFILE_IMAGE — TEXT
- HEIGHT — INTEGER
- WEIGHT — INTEGER
- AGE — INTEGER
- GENDER — BOOLEAN
- INPUT_COUNT — INTEGER
- AUTO_LOGIN — BOOLEAN
- LAST_LOGIN_DATE — TIMESTAMPTZ
- SANCTION_COUNT — INTEGER
- CREATE_DATE — TIMESTAMPTZ
- UPDATE_DATE — TIMESTAMPTZ
- PW — TEXT
- Field (ACTIVITY_LEVEL) — INTEGER
Untitled (BOARD)
- Key (BOARD_ID) — UUID — Primary key — NOT NULL
- Field (TITLE) — TEXT
- Field (CONTENT) — TEXT
- Field (CATEGORY) — INTEGER
- Field (IMAGE) — TEXT
- Field (USER_ID) — UUID
- Field (CREATE_DATE) — TIMESTAMPTZ
- Field (UPDATE_DATE) — TIMESTAMPTZ
- Field (BOARD_STATE) — INTEGER
Untitled (COMMENT)
- Key (COMMENT_ID) — UUID — Primary key — NOT NULL
- Field (BOARD_ID) — UUID
- Field (USER_ID) — UUID
- Field (CONTENT) — TEXT
- Field (CREATE_DATE) — TIMESTAMPTZ
- Field (UPDATE_DATE) — TIMESTAMPTZ
Untitled (REPORT)
- Key (REPORT_ID) — UUID — Primary key — NOT NULL
- Field (USER_ID) — UUID
- Field (CONTENT_ID) — UUID
- Field (CONTENT_TYPE) — INTEGER
- Field (REPORT_TYPE) — INTEGER
- Field (CONTENT) — TEXT
- Field (CREATE_DATE) — TIMESTAMPTZ
Untitled (SCRAP)
- Key (SCRAP_ID) — UUID — Primary key — NOT NULL
- Field (BOARD_ID) — UUID
- Field (USER_ID) — UUID
- Field (CREATE_DATE) — TIMESTAMPTZ
Untitled (LIKE)
- Key (LIKE_ID) — UUID — Primary key — NOT NULL
- Field (CONTENT_ID) — UUID
- Field (CONTENT_TYPE) — UUID
- Field (USER_ID) — UUID
- Field (CREATE_DATE) — UUID
Untitled (VIEW_COUNTER)
- Key (VIEW_ID) — UUID — Primary key — NOT NULL
- Field (BOARD_ID) — UUID
- Field (USER_ID) — UUID
Untitled (COMMON_CODE)
- Key (CODE_ID) — TEXT — Primary key — NOT NULL
- Field (GROUP_NAME) — TEXT
- Field (CODE_VALUE) — INTEGER
- Field (CODE_NAME) — TEXT