VEGUN_DIET_MANAGER_VIEWER
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
- 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_ID (DIET_TABLE_ID2) — UUID — Foreign key → DIET_TABLE.DIET_TABLE_ID — NOT NULL
DIET_TABLE
- DIET_TABLE_ID — UUID — Primary key — NOT NULL
- DIET_DATE — TIMESTAMPTZ
- DIET_TIME — INTEGER
- CREAT_DATE (CREATE_DATE) — TIMESTAMPTZ
- UPDATE_DATE — TIMESTAMPTZ
- ID (USER_ID) — UUID — Foreign key → MEMBER.ID — NOT NULL
MEMBER
- ID (USER_ID) — UUID — Primary key — NOT NULL
- NICKNAME — TEXT
- 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
Untitled (BOARD)
- Key (BOARD_ID) — UUID — Primary key — NOT NULL
- Field (TITLE) — TEXT
- Field (CONTENT) — TEXT
- Field (CATEGORY) — INTEGER
- Field (IMAGE) — TEXT
- Field (CREATE_DATE) — TIMESTAMPTZ
- Field (UPDATE_DATE) — TIMESTAMPTZ
- Field (BOARD_STATE) — INTEGER
- ID (USER_ID) — UUID — Foreign key → MEMBER.ID — NOT NULL
Untitled (COMMENT)
- Key (COMMENT_ID) — UUID — Primary key — NOT NULL
- Field (CONTENT) — TEXT
- Field (CREATE_DATE) — TIMESTAMPTZ
- Field (UPDATE_DATE) — TIMESTAMPTZ
- ID (USER_ID) — UUID — Foreign key → MEMBER.ID — NOT NULL
- Key (BOARD_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
Untitled (REPORT)
- Key (REPORT_ID) — UUID — Primary key — NOT NULL
- Field (REPORT_TYPE) — INTEGER
- Field (CONTENT) — TEXT
- Field (CREATE_DATE) — TIMESTAMPTZ
- ID (USER_ID) — UUID — Foreign key → MEMBER.ID — NOT NULL
- Key (BOARD_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
- Key (COMMENT_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
Untitled (SCRAP)
- Key (SCRAP_ID) — UUID — Primary key — NOT NULL
- Field (CREATE_DATE) — TIMESTAMPTZ
- Key (BOARD_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
- ID (USER_ID) — UUID — Foreign key → MEMBER.ID — NOT NULL
Untitled (LIKE)
- Key (LIKE_ID) — UUID — Primary key — NOT NULL
- Field (CREATE_DATE) — UUID
- Key (BOARD_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
- Key (COMMENT_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
- ID (USER_ID) — UUID — Foreign key → MEMBER.ID — NOT NULL
Untitled (VIEW_COUNTER)
- Key (VIEW_ID) — UUID — Primary key — NOT NULL
- Key (BOARD_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
- ID (USER_ID) — UUID — Foreign key → MEMBER.ID — NOT NULL
Untitled (COMMON_CODE)
- Key (CODE_ID) — TEXT — Primary key — NOT NULL
- Field (CODE_VALUE) — INTEGER
- Field (CODE_NAME) — TEXT
- Key (GROUP_NAME) — TEXT — Foreign key → COMMON_GROUP.Key — NOT NULL