P01_ACCOUNT

Tables (17)

ACCOUNT (Untitled3)

  • ACCOUNT_ID (Key) — Primary key — NOT NULL
  • ACCOUNT_NAME (Field)
  • DESCRIPTION (Field2)
  • INIT_MONEY (Field3)
  • BOOK_ID (Key2) — Foreign key → MY_BOOK.BOOK_ID — NOT NULL

API (Untitled9)

  • API_ID (Key) — Primary key — NOT NULL
  • HTTP_TYPE (Field)
  • URL (Field2)
  • RULE (Field3)
  • DESCRIPTION (Field4)

CATEGORY (Untitled2)

  • CATEGORY_ID (Key) — Primary key — NOT NULL
  • ACCOUNT_ID (Key2) — Foreign key → MY_BOOK.BOOK_ID — NOT NULL
  • CATEGORY_NAME (Field)
  • UP_CATEGORY (Field2)

COMM_CODE (Untitled14)

  • CODE_ID (Key) — Primary key — NOT NULL
  • CODE_NAME (Field)

MENU (Untitled4)

  • MENU_ID (Key) — Primary key — NOT NULL
  • MENU_NAME (Field)

MENU_ROLE (Untitled5)

  • MENU_ROLE_ID (Key3) — Primary key — NOT NULL
  • MENU_ID (Key) — Foreign key → MENU.MENU_ID — NOT NULL
  • ROLE_ID (Key2) — Foreign key → ROLE.ROLE_ID — NOT NULL

MENU_RULE (Untitled13)

  • Key — Primary key — NOT NULL
  • MENU_ID (Key2) — Foreign key → MENU.MENU_ID — NOT NULL
  • RULE_ID (Key3) — Foreign key → RULE.RULE_ID — NOT NULL

MODULE (Untitled7)

  • MODULE_ID (Key) — Primary key — NOT NULL

MY_BOOK (Untitled)

  • BOOK_ID (Key) — Primary key — NOT NULL
  • BOOK_NAME (Field)
  • DESCRIPTION (Field2)
  • USER_ID (사용자 아이디) — NUMBER — Foreign key → USER.USER_ID — NOT NULL

ROLE (Untitled6)

  • ROLE_ID (Key) — Primary key — NOT NULL
  • ROLE_NAME (Field)

ROLE_RULE (Untitled12)

  • ROLE_RULE_ID (Key) — Primary key — NOT NULL
  • ROLE_ID (Key2) — Foreign key → ROLE.ROLE_ID — NOT NULL
  • RULE_ID (Key3) — Foreign key → RULE.RULE_ID — NOT NULL

RULE (Untitled10)

  • RULE_ID (Key) — Primary key — NOT NULL
  • RULE_NAME (Field)
  • MODULE_ID (Key2) — Foreign key → MODULE.MODULE_ID — NOT NULL

RULE_API (Untitled11)

  • RULE_API_ID (Key3) — Primary key — NOT NULL
  • API_ID (Key) — Foreign key → API.API_ID — NOT NULL
  • RULE_ID (Key2) — Foreign key → RULE.RULE_ID — NOT NULL

USER (사용자)

  • USER_ID (사용자 아이디) — NUMBER — Primary key — NOT NULL
  • USER_NAME (사용자명) — VARCHAR2(30) — NOT NULL
  • EMAIL (이메일) — VARCHAR2(30) — NOT NULL

USER_AUTH (사용자 인증)

  • AUTH_ID (사용자 인증 아이디) — NUMBER — Primary key — NOT NULL
  • LOGIN_ID (로그인 아이디) — VARCHAR2(30) — NOT NULL
  • PASSWORD (패스워드) — VARCHAR2(30) — NOT NULL
  • USER_ID (사용자 아이디) — NUMBER — Foreign key → USER.USER_ID — NOT NULL

USER_ROLE (Untitled8)

  • USER_ROLE_ID (Key) — Primary key — NOT NULL
  • ROLE_ID (Key2) — Foreign key → ROLE.ROLE_ID — NOT NULL
  • USER_ID (사용자 아이디) — NUMBER — Foreign key → USER.USER_ID — NOT NULL

USER_TOKEN (사용자 토큰값)

  • USER_ID (사용자 아이디) — NUMBER — Foreign key → USER.USER_ID — NOT NULL
  • TOKEN (토큰값) — NOT NULL