role

Tables (15)

TB_BOARD (Untitled7)

  • boardOid (Key) — Primary key — NOT NULL
  • Field

TB_CONTENTS (Untitled9)

  • contentsOid (Key) — Primary key — NOT NULL

TB_MENU_CONFIG (Untitled8)

  • menuConfigOid (Key) — Primary key — NOT NULL
  • key (밸류) — 비밀댓글
  • useYn (Field)
  • VALUE (Field2)
  • Field3

TB_MENU_CONFIG_REL (Untitled10)

  • menuOid (Key) — Foreign key → menu.menuOid — NOT NULL
  • menuConfigOid (Key2) — Foreign key → TB_MENU_CONFIG.menuConfigOid — NOT NULL
  • Field

TB_MENU_CONFIG_REL_YN (Untitled11)

  • Key — Primary key — NOT NULL
  • menuOid (Key2) — Foreign key → TB_MENU_CONFIG_REL.menuOid — NOT NULL
  • menuConfigOid (Key22) — Foreign key → TB_MENU_CONFIG_REL.menuConfigOid — NOT NULL
  • roleOid (Key3) — Foreign key → TB_ROLE_MENU_REL.roleOid — NOT NULL
  • menuOid (Key23) — Foreign key → TB_ROLE_MENU_REL.menuOid — NOT NULL
  • Field2

TB_MENU_ITEM_REL (Untitled6)

  • menuOid (Key) — Foreign key → menu.menuOid — NOT NULL
  • boardOid (Key2) — Foreign key → TB_BOARD.boardOid — NOT NULL

TB_MENU_ITEM_REL (Untitled14)

  • rightOid (Key) — Foreign key → TB_RIGHT.rightOid — NOT NULL
  • menuOid (Key2) — Foreign key → TB_MENU_ITEM_REL.menuOid — NOT NULL
  • boardOid (Key22) — Foreign key → TB_MENU_ITEM_REL.boardOid — NOT NULL

TB_MENU_RIGHT_REL (Untitled13)

  • rightOid (Key) — Foreign key → TB_RIGHT.rightOid — NOT NULL
  • roleOid (Key2) — Foreign key → TB_ROLE_MENU_REL.roleOid — NOT NULL
  • menuOid (Key22) — Foreign key → TB_ROLE_MENU_REL.menuOid — NOT NULL

TB_RIGHT (Untitled12)

  • rightOid (Key) — Primary key — NOT NULL
  • jsonb (Field2)
  • insertYm (Field3)
  • updateYn (Field4)
  • deleteYn (Field5)
  • useYN (Field)

TB_ROLE (Untitled3)

  • roleOid (Key) — Primary key — NOT NULL

TB_ROLE_MENU_REL (_)

  • roleOid (Key) — Foreign key → TB_ROLE.roleOid — NOT NULL
  • menuOid (Key2) — Foreign key → menu.menuOid — NOT NULL

TB_ROLE_USER_REL (Untitled4)

  • userOid (Key) — Foreign key → TB_USER.userOid — NOT NULL
  • roleOid (Key2) — Foreign key → TB_ROLE.roleOid — NOT NULL

TB_USER (Untitled)

  • userOid (Key) — Primary key — NOT NULL

menu (Untitled5)

  • menuOid (Key) — Primary key — NOT NULL
  • jsonb

menu_lang (Untitled2)

  • menuOid (Key) — Foreign key → menu.menuOid — NOT NULL
  • lang (Field2)
  • menu_name (Field)