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