jpa_ddl_test
Tables (13)
TB_AUTHORITY
- authority_code — varchar(255) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- authority_name — varchar(255)
TB_AUTHORITY_MENU
- authority_code — varchar(255) — Foreign key → TB_AUTHORITY.authority_code — NOT NULL
- menu_no — int(11) — Foreign key → TB_MENU.menu_no — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
TB_MAIL_HISTORY
- email_uuid — varchar(255) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- content — varchar(255)
- email_send_at — datetime(6)
- email_to — varchar(255)
- email_token — varchar(255)
- email_type_code — char(1) — NOT NULL
- subject — varchar(255)
TB_MENU
- menu_no — int(11) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- description — varchar(255)
- is_active — bit(1) — NOT NULL
- menu_icon — varchar(255)
- menu_name — varchar(255)
- menu_type_code — char(1) — NOT NULL
- menu_url — varchar(255)
- order_no — int(11) — NOT NULL
- parent_menu_no — int(11) — NOT NULL
TB_ORGANIZATION
- organization_code — varchar(255) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- organization_name — varchar(255)
- organization_type_code — varchar(255)
- parent_organization_code — varchar(255)
TB_ORGANIZATION_ACCOUNT
- account_no — bigint(20) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- access_key — varchar(255)
- account_name — varchar(255)
- platform_type — varchar(255)
- secret_key — varchar(255)
- organization_code — varchar(255) — Foreign key → TB_ORGANIZATION.organization_code
TB_ORGANIZATION_DETAIL
- organization_code — varchar(255) — Foreign key → TB_ORGANIZATION.organization_code — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- address — varchar(255)
- address_detail — varchar(255)
- business_registration_number — varchar(255)
- description — varchar(255)
- representative_email — varchar(255)
- representative_name — varchar(255)
- representative_tel — varchar(255)
- zip_code — varchar(255)
TB_ROLE
- role_code — varchar(255) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- role_name — varchar(255)
TB_ROLE_AUTHORITY
- role_code — varchar(255) — Foreign key → TB_ROLE.role_code — NOT NULL
- authority_code — varchar(255) — Foreign key → TB_AUTHORITY.authority_code — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
TB_USER
- user_email — varchar(255) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- is_active — bit(1) — NOT NULL
- password — varchar(255)
- tel — varchar(255)
- user_name — varchar(255)
- organization_code — varchar(255) — Foreign key → TB_ORGANIZATION.organization_code
TB_USER_LOG_HISTORY
- log_no — bigint(20) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- accessed_at — datetime(6)
- ip_address — varchar(255)
- token_uuid — varchar(255)
- user_uuid — varchar(255) — Foreign key → TB_USER.user_email
TB_USER_ROLE
- role_code — varchar(255) — Foreign key → TB_ROLE.role_code — NOT NULL
- user_email — varchar(255) — Foreign key → TB_USER.user_email — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
TB_USER_SIGNUP
- email_uuid — varchar(255) — Primary key — NOT NULL
- created_at — datetime(6)
- created_by — varchar(255)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- updated_by — varchar(255)
- approved_at — datetime(6)
- approved_by — varchar(255)
- email_verified_at — datetime(6)
- is_approved — bit(1) — NOT NULL
- password — varchar(255)
- user_email — varchar(255)
- user_name — varchar(255)