hardcarry_db
Tables (8)
back_balance
- balance_id — VARCHAR(20) — Primary key — NOT NULL
- balance_content — VARCHAR(200)
- balance_date — DATE
- balance_like — INT
- balance_type — VARCHAR(2)
back_balance_like
- blike_id — VARCHAR(20) — Primary key — NOT NULL
- balance_id — VARCHAR(20) — Foreign key → back_balance.balance_id — NOT NULL
- blike_name — VARCHAR(20)
- blike_ip — VARCHAR(20)
- blike_date — DATE
- blike_browser — VARCHAR(20)
back_diary
- diary_id — VARCHAR(20) — Primary key — NOT NULL
- diary_writter — VARCHAR(20)
- diary_content — VARCHAR(500)
- diary_like — INT
- diary_date — DATE
- diary_ip — VARCHAR(20)
- diary_browser — VARCHAR(20)
back_diary_check
- diary_id — VARCHAR(20) — Foreign key → back_diary.diary_id — NOT NULL
- diary_checked — VARCHAR(2)
- diary_name — VARCHAR(10)
- diary_phone — VARCHAR(20)
back_diary_like
- dlike_id — VARCHAR(20) — Primary key — NOT NULL
- diary_id — VARCHAR(20) — Foreign key → back_diary.diary_id — NOT NULL
- dlike_name — VARCHAR(20)
- dlike_ip — VARCHAR(20)
- dlike_date — DATE
- dlike_browser — VARCHAR(20)
back_item
- item_id — VARCHAR(20) — Primary key — NOT NULL
- item_name — VARCHAR(50)
- item_desc — VARCHAR(200)
- item_img — VARCHAR(50)
- item_voted — INT
- item_hashtag — VARCHAR(50)
back_item_vote
- bvote_id — VARCHAR(20) — Primary key — NOT NULL
- item_id — VARCHAR(20) — Foreign key → back_item.item_id — NOT NULL
- bvote_name — VARCHAR(20)
- bvote_ip — VARCHAR(20)
- bvote_date — DATE
- bvote_browser — VARCHAR(20)
back_test
- type_id — VARCHAR(20) — Primary key — NOT NULL
- type_name — VARCHAR(50)
- type_desc — VARCHAR(200)
- type_img — VARCHAR(50)
- type_like — VARCHAR(20)
- type_dislike — VARCHAR(20)
- type_attend — INT