sdf

Tables (4)

NFT_profile_image

  • nft_image_id — VARCHAR(100) — Primary key — NOT NULL
  • nft_url — VARCHAR(100) — NOT NULL
  • artist — VARCHAR(100) — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL — 지갑 주소
  • user_id (user_id2) — VARCHAR(100) — Foreign key → users.user_id — NOT NULL — 지갑 주소

basic_profile_image

  • basic_image_id — VARCHAR(100) — Primary key — NOT NULL
  • image_url — VARCHAR(100) — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL — 지갑 주소
  • user_id (user_id2) — VARCHAR(100) — Foreign key → users.user_id — NOT NULL — 지갑 주소

friends

  • friend_id — VARCHAR(100) — Primary key — NOT NULL
  • to_user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL — 지갑 주소
  • from_user_id — VARCHAR(100) — NOT NULL
  • is_friend — INT — NOT NULL

users

  • user_id — VARCHAR(100) — Primary key — NOT NULL — 지갑 주소
  • user_email — VARCHAR(50) — NOT NULL
  • user_nickname — VARCHAR(50) — NOT NULL
  • country — VARCHAR(3) — NOT NULL
  • discord_link — VARCHAR(200)
  • twitch_link — VARCHAR(200)
  • twitter_link — VARCHAR(200)
  • youtube_link — VARCHAR(200)
  • game_penalty — INT — 추후 규정 참고
  • birth — DATETIME — NOT NULL
  • national_flag — VARCHAR(200) — 국가에 따라 저장
  • wallet_name — VARCHAR(200) — NOT NULL