DID_TOY_DB

Tables (6)

ADMIN (tb_admin)

  • 관리자번호 (admin_number) — NOTNULL — Primary key
  • 아이디 (admin_id) — NOT NULL
  • 이름 (admin_name) — NOT NULL
  • 비밀번호 (admin_password) — NOT NULL
  • 권한 (admin_grade) — NOT NULL

Badge (d)

  • 뱃지번호 (badge_num) — NOTNULL — Primary key
  • 뱃지이름 (badge_name) — NOT NULL
  • 생성날짜 (create_date) — NOTNULL
  • 뱃지형태 (badge_type) — NOTNULL

BlockCheck (CopyOftb_admin)

  • 숫자 (increase_num) — NOTNULL — Primary key
  • 해당블록 (klay_block_number) — NOT NULL
  • 해당Tx (klay_tx) — NOT NULL
  • TO (klay_to) — NOT NULL
  • memo (klay_memo) — NULL
  • 생성날짜 (create_date) — NOTNULL

BlockSearch (CopyOfCopyOftb_admin)

  • 숫자 (increase_num) — NOTNULL — Primary key
  • 해당블록 (klay_last_block_number) — NOT NULL
  • 생성날짜 (create_date) — NOTNULL
  • 컨트랙트주소 (contract_address) — NOTNULL

USER (tb_user)

  • 고객번호 (user_number) — NOT NULL — Primary key — NOT NULL
  • 수료생이름 (user_name) — NOT NULL
  • 수강프로그램 (user_program) — NOT NULL
  • 수료날짜 (user_complete_date) — NOTNULL
  • 교육기간 (user_edu_start_date) — NOT NULL
  • 부트캠프타입 (user_bootcamp_type) — NOTNULL
  • 기수 (usr_fundamental_number) — NOTNULL
  • DID (user_DID) — NOT NULL
  • 수료생지갑주소 (user_address) — NOTNULL

user_to_badge (CopyOfd)

  • 뱃지번호 (badge_num) — NOTNULL — Primary key
  • 고객번호 (Key) — NOTNULL — Primary key — NOT NULL
  • 뱃지이름 (badge_name) — NOT NULL
  • 뱃지형태 (badge_type) — NOTNULL