return7
Tables (6)
board
- id — bigint — Primary key — NOT NULL
- titlet (title) — varchar — NOT NULL
- content — varchar — NOT NULL
- view_count — int
- up_count — int
- down_count — int
- selected — boolean — NOT NULL
- selected_reply — id
- created_at — localdatetime — NOT NULL
- id (id2) — bigint — Foreign key → user.id
board_vote
- id — bigint — Primary key — NOT NULL
- votetype — varchar — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- board_id (id2) — bigint — Foreign key → board.id — NOT NULL
password_reset_token
- id — bigint — Primary key — NOT NULL
- experation_minutes — bigint — NOT NULL
- token — varchar — NOT NULL
- expired_at — localdatetime — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
reply
- id — bigint — Primary key — NOT NULL
- content (conten) — varchar — NOT NULL
- is_selected — boolean — NOT NULL
- recommendation — int — NOT NULL
- disrecommendation — int — NOT NULL
- created_at — localdatetime — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- user_id — bigint — Foreign key → user.id
- parent_id — bigint — Foreign key → reply.id
reply_vote
- id — bigint — Primary key — NOT NULL
- votedv (oted) — boolean
- user_id — bigint — Foreign key → user.id — NOT NULL
- reply_id — bigint — Foreign key → reply.id — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- loginid — varchar — NOT NULL
- password — varchar — NOT NULL
- authority — varchar — NOT NULL
- created_at — localdatetime — NOT NULL
- email — varchar