euratchaSetting

Tables (26)

Copy Of Copy Of Untitled2 (game_master_official_channel)

  • Field (SEQ) — smallint unsigned — Primary key — NOT NULL — 아이디
  • GAME_ID — smallint unsigned — Foreign key → game_master.GAME_ID — NOT NULL — 게임 ID
  • Field (CHANNEL_CD) — smallint unsigned — NOT NULL — 채널
  • Field (LINK) — varchar(256) — 링크

Copy Of Untitled (admin_auth_portal_map)

  • AUTH_GRP_ID — smallint — Foreign key → admin_auth_grp.AUTH_GRP_ID — 권한 아이디
  • ADMIN_ID — smallint unsigned — Foreign key → admin_portal.ADMIN_ID — NOT NULL — 어드민 아이디
  • ISACTIVATE — bit — 활성화 여부

Copy Of Untitled2 (game_browser_contents)

  • GAME_ID — smallint — Foreign key → Untitled.GAME_ID — NOT NULL — 게임 ID
  • Field (CONTENTS) — text — NOT NULL — 내용

Copy Of admin_auth_grp2 (admin_member_auth_grp)

  • AUTH_GRP_ID — smallint — Primary key — 권한 아이디
  • BIZ_SCOPE — varchar(20) — NOT NULL — 업무 범위 (PORTAL / GAME)
  • AUTH_NM — varchar(100) — NOT NULL — 권한명
  • DESCRIPTION — varchar(1000) — 설명
  • ISACTIVATE — bit — 활성화여부
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — NOT NULL — 생성자
  • UPDATED_BY — smallint — 수정자

Copy Of admin_auth_grp_menu_map (admin_auth_grp_menu_map)

  • MEMU_ID (MENU_ID) — smallint — Foreign key → admin_menu.MEMU_ID — NOT NULL — 메뉴아이디
  • AUTH_GRP_ID — smallint — Foreign key → admin_auth_grp.AUTH_GRP_ID — NOT NULL — 권한 아이디
  • ISREAD — bit — 읽기여부
  • ISEDIT — bit — 수정여부
  • ISACTIVATE — bit — 활성화여부

Copy Of admin_connect_log (admin_auth_grp_history)

  • SEQ — int — Primary key — NOT NULL — 일련번호
  • ADMIN_ID — smallint unsigned — Foreign key → admin_base.ADMIN_ID — NOT NULL — 어드민 아이디
  • Field (BIZ_SCOPE) — varchar(20) — NOT NULL — 업무 범위 (PORTAL / GAME)
  • CONN_IP (OLD_AUTH_GRP_ID) — smallint — NOT NULL — 변경전 권한그룹
  • CONN_CATEGORY_NM (NEW_AUTH_GRP_ID) — smallint — NOT NULL — 변경후 권한그룹
  • Field (PROCESS_BY) — smallint — NOT NULL — 처리자 어드민아이디
  • Field (PROCESS_NM) — varchar(255) — 처리자 어드민명
  • CREATED_AT — timestamp — 생성일시

Copy Of admin_menu (admin_game_menu_library)

  • MEMU_ID (LIBARAY_MENU_ID) — smallint — Primary key — NOT NULL — 메뉴라이브러리아이디
  • MENU_NM — varchar(100) — 메뉴명
  • PATH — varchar(255) — 메뉴 주소
  • PARENT_ID — smallint — 부모 아이디
  • PARENT_ORDER (DISPLAY_ORDER) — tinyint — 노출 순서
  • DESCRIPTION — varchar(2000) — 설명
  • IMAGE_URL — varchar(250) — 이미지URL
  • ISACTIVATE (ISVISUABLE) — bit — 노출여부
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — NOT NULL — 생성자
  • UPDATED_BY — smallint — 수정자

Untitled (game_browser_intro_image)

  • SEQ — int unsigned — Primary key — NOT NULL — 아이디
  • GAME_ID — smallint unsigned — Foreign key → Untitled.GAME_ID — NOT NULL — 게임 ID
  • Field (IMAGE_URL) — varchar(256) — NOT NULL — 이미지 URL

Untitled (game_browser_pre_register_terms)

  • GAME_ID — smallint — Foreign key → Untitled.GAME_ID — NOT NULL — 게임 ID
  • Field (CONTENTS) — text — NOT NULL — 내용

Untitled (game_browser)

  • GAME_ID — smallint unsigned — Foreign key → game_master.GAME_ID — NOT NULL — 게임 ID
  • Field (ISPRE_REGISTER) — bit — NOT NULL — 사전등록여부
  • Field (REQUIERD_CODITION_TAG) — varchar(50) — 실행조건
  • Field (RECOMMENDED_BROWSER_TAG) — varchar(200) — NOT NULL — 권장 브라우저
  • Field (SUPPORT_DEVICE_TAG) — varchar(200) — NOT NULL — 지원기기

Untitled (game_installable)

  • GAME_ID — smallint unsigned — Foreign key → game_master.GAME_ID — NOT NULL — 게임 ID
  • Field (GAME_ABBR) — varchar(50) — NOT NULL — 약어
  • Field (MAIN_IMAGE_URL) — varchar(250) — 대표이미지 URL
  • Field (SUB_IMAGE_URL) — varchar(250) — 서브 이미지 URL
  • Field (RATING_IMAGE_URL) — varchar(255) — 게임이용등급 이미지 URL
  • Field (PROFILE_GAME_START_IMAGE_URL) — varchar(255) — 프로필 게임시작 URL
  • Field (GNB_GAME_START_IMAGE_URL) — varchar(255) — GNB 게임시작 URL
  • Field (PLATFORM_TAG) — varchar(500) — 플랫폼 태그

Untitled (admin_game_map)

  • ADMIN_ID — smallint unsigned — Foreign key → admin_game.ADMIN_ID — NOT NULL — 어드민 아이디
  • GAME_ID — smallint — Foreign key → game_master.GAME_ID — NOT NULL — 게임 ID
  • Field (NICK_NM) — varchar(50) — 노출닉네임

Untitled (admin_auth_game_map)

  • ADMIN_ID — smallint unsigned — Foreign key → admin_game.ADMIN_ID — NOT NULL — 어드민 아이디
  • AUTH_GRP_ID — smallint — Foreign key → admin_auth_grp.AUTH_GRP_ID — NOT NULL — 권한 아이디
  • ISACTIVATE — bit — 활성화 여부

admin_auth_grp

  • AUTH_GRP_ID — smallint — Primary key — NOT NULL — 권한 아이디
  • Field (BIZ_SCOPE) — varchar(20) — NOT NULL — 업무 범위 (PORTAL / GAME)
  • GAME_UNIQUE_KEY (GAME_ID) — smallint unsigend — 게임 ID
  • AUTH_NM — varchar(100) — NOT NULL — 권한명
  • DESCRIPTION — varchar(1000) — 설명
  • ISACTIVATE — bit — 활성화여부
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — NOT NULL — 생성자
  • UPDATED_BY — smallint — 수정자

admin_auth_grp_menu_map (admin_member_auth_grp_menu_map)

  • MEMU_ID (MENU_ID) — smallint — Foreign key → admin_portal_menu.MEMU_ID — 메뉴아이디
  • AUTH_GRP_ID — smallint — Foreign key → Copy Of admin_auth_grp2.AUTH_GRP_ID — 권한 아이디
  • ISREAD — bit — 읽기여부
  • ISEDIT — bit — 수정여부

admin_base

  • ADMIN_ID — smallint unsigned — Primary key — NOT NULL — 어드민 아이디
  • ADMIN_ACCOUNT — varchar(100) — NOT NULL — 어드민 계정
  • ADMIN_NM — varchar(255) — 어드민 이름
  • EMAIL — varchar(255) — 이메일

admin_connect_log

  • SEQ — int — Primary key — NOT NULL — 일련번호
  • ADMIN_ID — smallint unsigned — Foreign key → admin_base.ADMIN_ID — NOT NULL — 어드민 아이디
  • CONN_IP — int — 접속 아이피 정보
  • Field (BIZ_SCOPE) — varchar(20) — NOT NULL — 업무 범위 (PORTAL / GAME)
  • CONN_CATEGORY_NM — varchar(100) — NOT NULL — 접속카테고리명
  • CREATED_AT — timestamp — 생성일시

admin_game

  • ADMIN_ID — smallint unsigned — Foreign key → admin_base.ADMIN_ID — NOT NULL — 어드민 아이디
  • Field (PWD) — varchar(256) — NOT NULL — 사용비밀번호
  • PWD_FAILED_CNT — tinyint — 사용자 비밀번호 틀린 횟수
  • ISACTIVATE — bit — 활성화여부
  • LAST_CONN_IP — int — 마지막 로그인 아이피
  • EXPIRED_AT — timestamp — 사용자 사용기간 일
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — 생성자
  • UPDATED_BY — smallint — 수정자

admin_member

  • Field (ADMIN_ID) — smllint — Primary key — 어드민아이다
  • LAST_CONN_IP — int — 마지막 로그인 아이피
  • PWD_FAILED_CNT — tinyint — 사용자 비밀번호 틀린 횟수
  • ISACTIVATE — bit — 활성화여부
  • EXPIRED_AT — timestamp — 사용자 사용기간 일
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — 생성자
  • UPDATED_BY — smallint — 수정자
  • AUTH_GRP_ID — smallint — Foreign key → Copy Of admin_auth_grp2.AUTH_GRP_ID — 권한 아이디
  • Field2 (ADMIN_ACCOUNT) — varchar(100) — 어드민계정
  • Field (ADMIN_NM) — varchar(255) — 어드민 이름
  • Field2 (EMAIL) — varchar(255) — 이메일

admin_member_password_history (admin_password_history)

  • SEQ — smallint — Primary key — 일련번호
  • ADMIN_ID — smallint unsigned — Foreign key → admin_base.ADMIN_ID — NOT NULL — 어드민 아이디
  • Field (BIZ_SCOPE) — varchar(20) — NOT NULL — 업무 범위 (PORTAL / GAME)
  • ADMIN_NM — varchar(255) — 변경 어드민명
  • PROCESS_BY — smallint — NOT NULL — 처리자 어드민ID
  • PROCESS_NM — varchar(255) — 처리자 어드민명
  • CREATED_AT — timestamp — NOT NULL — 생성일시

admin_menu

  • MEMU_ID (MENU_ID) — smallint — Primary key — NOT NULL — 메뉴아이디
  • Field (BIZ_SCOPE) — varchar(20) — NOT NULL — 업무 범위 (PORTAL / GAME)
  • GAME_CODE (GAME_ID) — smallint_unsigend — 게임 ID
  • Field (LIBARAY_MENU_ID) — smallint — 메뉴라이브러리아이디
  • MENU_NM — varchar(100) — 메뉴명
  • PATH — varchar(255) — 메뉴 주소
  • PARENT_ID — smallint — 부모 아이디
  • PARENT_ORDER (DISPLAY_ORDER) — tinyint — 노출순서
  • DESCRIPTION — varchar(2000) — 설명
  • IMAGE_URL — varchar(250) — 이미지URL
  • ISACTIVATE — bit — 활성화여부
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — NOT NULL — 생성자
  • UPDATED_BY — smallint — 수정자

admin_portal

  • ADMIN_ID — smallint unsigned — Foreign key → admin_base.ADMIN_ID — NOT NULL — 어드민 아이디
  • Field (PWD) — varchar(256) — NOT NULL — 사용자비밀번호
  • PWD_FAILED_CNT — tinyint — 사용자 비밀번호 틀린 횟수
  • ISACTIVATE — bit — 활성화여부
  • LAST_CONN_IP — int — 마지막 로그인 아이피
  • EXPIRED_AT — timestamp — 사용자 사용기간 일
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — 생성자
  • UPDATED_BY — smallint — 수정자

admin_portal_menu (admin_member_menu)

  • MEMU_ID (MENU_ID) — smallint — Primary key — 메뉴아이디
  • BIZ_SCOPE — varchar(10) — NOT NULL — 업무범위(PORTAL/MEMBER)
  • MENU_NM — varchar(100) — 메뉴명
  • PATH — varchar(255) — 메뉴 주소
  • PARENT_ID — smallint — 부모 아이디
  • PARENT_ORDER — tinyint — 부모 순서
  • DESCRIPTION — varchar(2000) — 설명
  • IMAGE_URL — varchar(250) — 이미지URL
  • ISACTIVATE — bit — 활성화여부
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_AT — timestamp — 수정일
  • CREATED_BY — smallint — NOT NULL — 생성자
  • UPDATED_BY — smallint — 수정자

common_code

  • MAIN_CODE_ID — char(4) — Primary key — NOT NULL — 대분류코드
  • CODE_ID — smallint unsigend — Primary key — NOT NULL — 코드 아이디
  • CODE_NAME — varchar(100) — NOT NULL — 코드명
  • ISACTIVE — bit — NOT NULL — 사용여부
  • COMMENTS — varchar(1000) — 내용
  • DISPLAY_ORDER — tinyint — 노출순서
  • IMAGE_URL — varchar(250) — 이미지URL
  • LINK — varchar(250) — 링크
  • CREATED_BY — smallint — NOT NULL — 생성자
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_BY — smallint — 수정자
  • UPDATED_AT — timestamp — 수정일시

common_main_code

  • MAIN_CODE_ID — smallint unsigend — Primary key — NOT NULL — 대분류코드 ID
  • Key (MAIN_CODE) — char(4) — NOT NULL — 대분류코드
  • Field (BIZ_SCOPE) — varchar(20) — NOT NULL — 업무 범위 (COMMON/PORTAL / GAME)
  • Field (GAME_ID) — smallint unsigend — 게임 ID
  • CODE_NAME — varchar(100) — NOT NULL — 코드명
  • ISACTIVE — bit — NOT NULL — 사용여부
  • COMMENTS — varchar(1000) — 내용
  • CREATED_BY — smallint — NOT NULL — 생성자
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_BY — smallint — 수정자
  • UPDATED_AT — timestamp — 수정일시

game_master

  • GAME_ID — smallint unsigned — Primary key — NOT NULL — 게임 ID
  • GAME_NAME — varchar(200) — NOT NULL — 게임명
  • ISVISIBLE — bit — NOT NULL — 노출여부
  • Field (GAME_UNIQUE_KEY) — varchar(15) — 게임식별자
  • RATING_CODE (RATING_CD) — smallint unsgined — NOT NULL — 이용등급 코드
  • GENRE_CODE (GENRE_CD) — smallint unsigned — NOT NULL — 장르 코드
  • OPEN_AT — timestamp — 오픈 일시
  • Field (OPERATOR_NICK_NM) — varchar(100) — NOT NULL — 운영자 기본 닉네임
  • Field (ISPRE_REGISTER) — bit — NOT NULL — 사전등록여부
  • Field (PRE_REGISTER_START_AT) — timestamp — 사전등록 시작일시
  • Field (PRE_REGISTER_END_AT) — timestamp — 사전등록 종료일시
  • Field (PRE_REGISTER_LINK) — varchar(255) — 사전등록 링크
  • CREATED_BY — smallint — NOT NULL — 생성자
  • CREATED_AT — timestamp — NOT NULL — 생성일시
  • UPDATED_BY — smallint — 수정자
  • UPDATED_AT — timestamp — 수정일시