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