bear_attack

Tables (3)

comment

  • comment_id — int — Primary key — NOT NULL
  • content — varchar(200)
  • parent_id — int
  • post_id — int — NOT NULL
  • user_id — int — NOT NULL

user

  • user_id — int — Primary key — NOT NULL
  • email — varchar(50)
  • password — varchar(200)
  • phone — varchar(20)
  • gender — enum('MALE','FEMALE')
  • birth — timestamp
  • name — varchar(10)
  • nickname — varchar(10)
  • profile_image — text
  • introduce — varchar(100)

user_comment_like

  • user_comment_like_id — int — Primary key — NOT NULL
  • comment_id — int — NOT NULL
  • user_id — int — NOT NULL