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)