mpoffice final
Tables (10)
alarm
- id — int
- creater_id — int — NOT NULL
- meme_id — int — NOT NULL
- auction_id — int
- comment_id — int
- type — enum
- created_at — timestamp — NOT NULL
- checked — tinyint
- user_id — int — NOT NULL
comment
- id — int
- user_id — int — NOT NULL
- meme_id — int — NOT NULL
- parent_comment_id — int
- content — varchar(255)
- is_valid — enum — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
meme
- id — int
- creater_id — int — NOT NULL
- owner_id — int — NOT NULL
- title — varchar(255)
- content — varchar(255)
- created_at — timestamp — NOT NULL
- imageurl — varchar(255)
- situation — varchar(255)
- count — int
- token_id — int
- contract_address — varchar(255)
- searched — int
- createrid — int
notification
- id — int
- user_id — int — NOT NULL
- type — enum — NOT NULL
- message — varchar(255)
- image_url — varchar(255)
- nft_id — int
- created_at — timestamp — NOT NULL
search_results
- id — int
- date — timestamp
- title — varchar(255)
- created_at — datetime — NOT NULL
transaction
- id — int
- meme_id — int — NOT NULL
- buyer_id — int — NOT NULL
- seller_id — int — NOT NULL
- created_at — timestamp
- price — int
- result — tinyint(1) — NOT NULL
user
- id — int
- name — varchar(20)
- email — varchar(255)
- nickname — varchar(20)
- profile_image — varchar(255)
- wallet_address — varchar(255)
- is_valid — enum — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- withdrawal_reason — varchar(255)
- today_meme_count — int — NOT NULL
- today — datetime
user_comment_like
- comment_id — int — Primary key — NOT NULL
- user_id — int — Primary key — NOT NULL
user_meme_auction_alert
- meme_id — int — Primary key — NOT NULL
- user_id — int — Primary key — NOT NULL
- cart — enum
user_meme_like
- meme_id — int — Primary key — NOT NULL
- user_id — int — Primary key — NOT NULL
- meme_like — enum
- date — datetime