skp_2023

Tables (5)

BRAND

  • brand_id — bigint — Primary key — NOT NULL

NFT

  • minting_nft_id — bigint — Primary key — NOT NULL
  • composite_yn — tinyint — NOT NULL — 합성여부
  • composite_req_date_time — datetime — NOT NULL — 합성일자
  • tem_id — bigint — Foreign key → TEM.tem_id — NOT NULL

TEM

  • tem_id — bigint — Primary key — NOT NULL
  • created_by — bigint — NOT NULL
  • created_date_time — datetime — NOT NULL
  • last_modified_by — bigint
  • last_modified_date_time — datetime
  • name — varchar
  • description — varchar
  • tem_type — varchar
  • location — varchar — 장착 부위?
  • tem_status — varchar
  • use_level_limit — int — 사용 레벨 제한?
  • win_start_date_time — datetime — 응모 시작일시?
  • win_end_date_time — datetime — 응모 종료일시?
  • use_start_date_time — datetime — 사용 시작일시?
  • use_end_date_time — datetime — 사용 종료일시?
  • use_count — int — 사용횟수?
  • minting_count — int
  • obtain_way — varchar — 획득 방법?
  • media_data — varchar
  • has_benefit — tinyint
  • benefit_type — varchar — 혜택 유형?
  • send_yn — tinyint — 전송 가능 여부?
  • trade_yn — tinyint — 거래 가능 여부?
  • overlap_yn — tinyint — 중복 가능 여부?
  • airdrop_yn — tinyint — 에어드랍여부?
  • brand_id — bigint — Foreign key → BRAND.brand_id

TEM_EXPOSE_DISP

  • id — bigint — Primary key — NOT NULL
  • page_name — varchar
  • disp_order — tinyint
  • description1 — varchar
  • tem_id — bigint — Foreign key → TEM.tem_id — NOT NULL

USER

  • id — bigint — Primary key — NOT NULL
  • mbr_id — bigint — NOT NULL
  • level — tinyint — NOT NULL
  • nft_membership_yn — tinyint
  • tutorial_yn — tinyint
  • wallet_address — varchar
  • wallet_connect_yn — tinyint
  • wallet_connect_date_time — datetime
  • uptn_rejoin_yn — tinyint
  • created_date_time — datetime