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