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