miraclebird

Tables (12)

Challenge

  • challenge_idx (Key) — Long — Primary key — NOT NULL
  • title — Varchar(64)
  • content — Varchar(256)

Challenger

  • challenger_idx — Long — Primary key — NOT NULL
  • Field
  • challenge_idx (Key) — Long — Foreign key → Challenge.challenge_idx — NOT NULL
  • user_idx — Long — Foreign key → User.user_idx — NOT NULL

Comment

  • comment_idx (Key) — Primary key — NOT NULL
  • content — Varchar(256)
  • regtime
  • post_idx — Long — Foreign key → Post.post_idx — NOT NULL
  • user_idx — Long — Foreign key → User.user_idx — NOT NULL

Landmark

  • landmark_idx — Long — Primary key — NOT NULL
  • selling — Boolean
  • sell_price — Long
  • star_force — Int
  • hash — Varchar(256)
  • user_idx — Long — Foreign key → User.user_idx — NOT NULL
  • landmark_info_idx — Long — Foreign key → Landmark_Info.landmark_info_idx — NOT NULL

Landmark_Info

  • landmark_info_idx — Long — Primary key — NOT NULL
  • province — Varchar(64)
  • city — Varchar(64)
  • dongCode — Int
  • title — Varchar(64)
  • content — Varchar(256)

Post

  • post_idx — Long — Primary key — NOT NULL
  • title — Varchar(64)
  • content — Varchar(256)
  • regtime — LocalDateTime
  • hit — Int
  • user_idx — Long — Foreign key → User.user_idx — NOT NULL

Price

  • price_idx — Long — Primary key — NOT NULL
  • gas_price — Varchar(256)
  • hash — Varchar(256)
  • sell_date — LocalDateTime
  • sell_price — Long
  • user_from — Varchar(256)
  • user_to — Varchar(256)
  • landmark_idx — Long — Foreign key → Landmark.landmark_idx — NOT NULL

Token (Untitled)

  • user_email — Varchar(64) — Primary key — NOT NULL
  • create_date — LocalDateTime
  • modified_date — LocalDateTime
  • refresh_token — Varchar(64)

User

  • user_idx — Long — Primary key — NOT NULL
  • created_date — LocalDateTime
  • modified_date — LocalDateTime
  • email — Varchar(64)
  • image_url — Varchar(256)
  • ether_coin — Long
  • mira_token — Long
  • name — Varchar(64)
  • password — Varchar(64)
  • provider — Varchar(64)
  • role — Varchar(64)
  • wallet — Varchar(256)
  • kakao_token — Varchar(256)
  • token_period — LocalDateTime

Verification

  • verification_idx — Long — Primary key — NOT NULL
  • regtime — LocalDateTime
  • selfie — Varchar(256)
  • share — Boolean
  • approval — Long
  • challenge_idx — Long — Foreign key → Challenge.challenge_idx — NOT NULL
  • user_idx — Long — Foreign key → User.user_idx — NOT NULL

Verification_Like

  • verification_like_idx — Long — Primary key — NOT NULL
  • verification_idx — Long — Foreign key → Verification.verification_idx — NOT NULL
  • user_idx — Long — Foreign key → User.user_idx — NOT NULL

Wallet

  • wallet_idx — Long — Primary key — NOT NULL
  • wallet_address — Long
  • mira_coin — Long
  • ether_coin — Long
  • user_idx — Long — Foreign key → User.user_idx — NOT NULL