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