lgcns_team6_mini1
Tables (6)
BOARD
- board_id — INT — NOT NULL
- user_id — INT — NOT NULL
- board_type — VARCHAR(20)
- title — VARCHAR(100)
- content — VARCHAR(500)
- created_at — DATETIME
- updated_at — DATETIME
- view_count — INT
- like_count — INT
COMMENT
- comment_id — INT — NOT NULL
- board_id — INT — NOT NULL
- user_id — INT — NOT NULL
- CONTENT — VARCHAR(100)
- created_at — DATETIME
STUDYCOMMUNITY
- board_id — INT — NOT NULL
- user_id — INT — NOT NULL
- recruit_count — INT
- current_count — INT
- start_date — DATETIME
- end_date — DATETIME
USER
- user_id — INT — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(100)
- name — VARCHAR(100)
- birthday — DATETIME
USER_SCRAB
- userscrab_id — INT — NOT NULL
- user_id — INT — NOT NULL
- board_id — INT — NOT NULL
- user_id2 — INT — NOT NULL
- like_Type — VARCHAR(20)
USER_TODOLIST
- todo_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — VARCHAR(200)
- is_done — BOOLEAN
- start_date — DATETIME
- end_date — DATETIME