yoga hub

Tables (4)

Board (board)

  • board_id — num — Primary key — NOT NULL
  • email — char — Foreign key → User.email — NOT NULL
  • title — char
  • content — char
  • created_at — datetime
  • updated_at — datetime

Comment (comment)

  • comment_id — num — Primary key — NOT NULL
  • board_id — num — Foreign key → Board.board_id — NOT NULL
  • email — char — Foreign key → Board.email — NOT NULL
  • comment_title — char
  • comment_content — char
  • created_at — datetime
  • updated_at — datetime

User (user)

  • email — char — Primary key — NOT NULL
  • password — char
  • nickname — varchar(20)

YogaInfo (yogainfo)

  • yoga_id — char — Primary key — NOT NULL
  • yoga_type — varchar(20)
  • yoga_name — varchar(20)
  • content — text
  • effect — text
  • warning — text