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