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