Test

okky erd

Tables (27)

Copy Of Copy Of Copy Of Copy Of Untitled3 (group_event_update)

  • Key (id) — int — Primary key — NOT NULL
  • Field (group_id) — int
  • Field (nonce) — int
  • Field (user_address) — binary(20)
  • Field (transaction_hash) — binary(20)
  • Field (block) — int
  • Field (logIndex) — int
  • Field (created_at) — datetime

Copy Of Copy Of Copy Of Untitled3 (group_event_create)

  • Key (id) — int — Primary key — NOT NULL
  • Field (group_id) — int
  • Field (nonce) — int
  • Field (user_address) — binary(20)
  • Field (total_count) — int
  • Field (transaction_hash) — binary(20)
  • Field (block) — int
  • Field (logIndex) — int
  • Field (created_at) — datetime

Copy Of Copy Of Untitled5 (group)

  • Key (id) — int — Primary key — NOT NULL
  • Key (nonce) — int — Primary key — NOT NULL
  • Field (parent_group_id) — int
  • Field (nft_id) — int
  • Field (name) — varchar(100)
  • Field (owner_address) — binary(20)
  • Field (description) — text
  • Field (merkle_hash) — binary(20)
  • Field (total_count) — int
  • Field (total_weight)
  • Field (image)
  • Field (type) — string
  • Field (status) — tinyint
  • Field (created_at) — datetime

Copy Of Untitled (airdrop_mission_participants)

  • Field (user_address) — Primary key
  • Key (mission_id) — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled2 (airdrop_event_distribute)

  • Field (airdrop_address) — binary(20) — Foreign key → Untitled.Field
  • Field (transaction_hash) — tinyint
  • Field (block)
  • Field (logIndex)
  • Field (created_at) — datetime
  • Field (user_address) — binary(20)
  • Field (token)
  • Field (totalAmount)
  • Field (target)
  • Field (amount)

Untitled (launch_description)

  • Field (launch_address) — binary(20) — Foreign key → Untitled.Field
  • Field (description) — text
  • Field (email) — varchar(255)
  • Field (site) — varchar(255)
  • Field (whiteBookLink) — varchar(255)
  • Field (telegram) — varchar(255)
  • Field (xLink) — varchar(255)
  • Field (discord) — varchar(255)

Untitled (group_nonce)

  • Key (group_id) — int — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (nonce) — int — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (merkle_hash) — binary(20)
  • Field (total_weight) — int
  • Field (total_count) — int
  • Field (created_at) — datetime

Untitled (group_nonce_participants)

  • Key (group_id) — int — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (nonce) — int — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (address) — int
  • Field (weight)
  • Field (json)

Untitled (user_score)

  • Key (address) — Primary key — NOT NULL
  • Field (rank)

Untitled (telegram)

  • Key (id) — Primary key — NOT NULL
  • Field (telegram_channel_id)
  • Field (name)
  • Field (participants_count)
  • Field (owner_uuid)
  • Field (logo)

Untitled (mission_type)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(100)
  • Field (description)
  • Field (action) — varchar(100)
  • Field (type)
  • Field (status) — varchar(100)
  • Field (point)

Untitled (airdrop_participants)

  • id (user_address) — binary(20) — Foreign key → user.id — NOT NULL
  • Field (airdrop_address) — binary(20) — Foreign key → Untitled.Field
  • Field (distributed_amount) — amount
  • Field (distribute_index) — binary(32)

Untitled (launchpad_vesting)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (launch_address) — binary(20) — Foreign key → Untitled.Field
  • Field (admin_address) — binary(20)
  • Field (issuer_address) — binary(20)
  • Field (cliff) — binary(32)
  • Field (halving) — binary(32)
  • Field (half_life) — binary(32)
  • Field (time_amount) — binary(32)
  • Field (total_amount) — binary(32)
  • Field (name) — varchar(100)

Untitled (launchpad_pool)

  • Field (launch_address) — binary(20) — Foreign key → Untitled.Field
  • Field (pool_type) — varchar(100)
  • Field (createor_address) — binary(40)
  • Field (token_amount) — bigint — NOT NULL
  • Field (target_address) — binary(40)
  • Field (target_amount) — bigint
  • Field (fee) — int
  • Field (need) — boolean
  • Field (status) — int
  • Field (created_at) — datetime

Untitled (banner)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (backgroundImage) — varchar(255)
  • Field

Untitled (launchpad)

  • Field (launch_address) — binary(20) — Primary key
  • Field (deployer) — binary(20)
  • Field (token_address)
  • Field (owner_address) — binary(20)
  • Field (unfreeze_time) — datetime
  • Field (lp_claimable_time) — datetime
  • Field (airdrop_amount) — bigint
  • Field (airdrop_description) — varchar(100)
  • Field (pool_volume) — decimal(32,6)
  • Field (max_volume_personly) — decimal(32,6)
  • Field (type) — tinyint
  • Field (status) — tinyint
  • Field (created_at) — datetime
  • id (space_id) — bigint(20) — Foreign key → space.id — NOT NULL

Untitled (airdrop_mission)

  • Key (id) — int — Primary key — NOT NULL
  • Field (airdrop_address) — binary(20) — Foreign key → Untitled.Field
  • Key (mission_type) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (param1)
  • Field (param2)

Untitled (airdrop_group_target)

  • Field (airdrop_address) — binary(20) — Foreign key → Untitled.Field
  • Key (group_id) — int — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (nonce) — int — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL

Untitled (airdrop_event_claim)

  • Field (airdrop_address) — binary(20) — Foreign key → Untitled.Field
  • Field (transaction_hash) — tinyint
  • Field (block)
  • Field (logIndex)
  • Field (created_at) — datetime
  • Field (user_address) — binary(20)
  • Field (token)
  • Field (index)
  • Field (amount)

Untitled (airdrop)

  • Field (address) — binary(20) — Primary key
  • Field (deployer) — binary(20)
  • Field (owner_address) — binary(20)
  • Field (token_address) — binary(20)
  • Field (claimable_time)
  • Field (merkle_root)
  • Field (description)
  • Field (total_amount) — binary(32)
  • Field (total_count)
  • Field (total_weight) — bigint
  • Field (liquidity_address) — binary(20)
  • Field (created_at) — datetime
  • Field (started_at) — datetime
  • Field (nft_id)

Untitled (token)

  • Key (address) — binary(40) — Primary key — NOT NULL
  • Field (deployer) — binary(40)
  • Field (minter) — binary(40)
  • Field (symbol) — varcdhar(100)
  • Field (name) — varchar(100)
  • Field (total_supply) — bigint — NOT NULL
  • Field (image) — varchar(100)
  • Field (remain) — bigint
  • Field (decimals) — int
  • Field (chain) — varchar(100)
  • Field

follow (space_follow)

  • follower_id (space_id) — bigint(20) — Foreign key → space.id — NOT NULL
  • Key (user_id) — Foreign key → user.Key — NOT NULL

space

  • id — bigint(20) — Primary key — NOT NULL
  • Field (owner_address)
  • version (name) — varchar(100) — NOT NULL
  • activity_point (description) — text — NOT NULL
  • nickname (logo) — varchar(255) — NOT NULL
  • official (url) — varchar(255)
  • Field (group_id)
  • Field (telegram_channel_id)
  • Field (owner_uuid)
  • Field (follow_count)
  • picture (status) — tinyint — NOT NULL
  • picture_type (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime

space_tag

  • avatar_tags_id (space_id) — bigint(20) — Foreign key → space.id
  • tag_id — bigint(20) — Foreign key → tag.id

spam_word

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • text — varchar(255) — NOT NULL

tag

  • id — bigint(20) — Primary key — NOT NULL
  • date_created — datetime — NOT NULL
  • description — varchar(255)
  • name — varchar(255) — NOT NULL
  • tagged_count (tagged_count_space) — int(11) — NOT NULL

user

  • Key (id) — int — Primary key — NOT NULL
  • id (address) — binary(20) — Primary key — NOT NULL
  • telegram_id (telegram_uuid) — varchar(255) — Primary key
  • username — varchar(15) — NOT NULL
  • account_locked — bit(1) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL