dbmodel
Tables (24)
achievement
- achievement_id — VARCHAR(50) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- photo — VARCHAR(255) — NOT NULL
- acquisition_condition — TEXT — NOT NULL
- location — TEXT — NOT NULL
alert
- alert_id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- alert_content — TEXT — NOT NULL
- alert_date — DATETIME — NOT NULL
- alert_read — TINYINT — NOT NULL
board
- board_id — INTEGER — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- post_date — DATETIME — NOT NULL
- view_count — INTEGER — NOT NULL
- is_public — TINYINT — NOT NULL
- is_deleted — TINYINT — NOT NULL
board_photo
- photo_id — INTEGER — Primary key — NOT NULL
- board_id — INTEGER — Foreign key → board.board_id — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- origin_filename — VARCHAR(255) — NOT NULL
board_tag
- tag_id — INTEGER — Primary key — NOT NULL
- board_id — INTEGER — Foreign key → board.board_id — NOT NULL
- tag_name — VARCHAR(255)
chat
- chat_id — INTEGER — Primary key — NOT NULL
- board_id — INTEGER — Foreign key → board.board_id — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- chat_content — TEXT — NOT NULL
- chat_date — DATETIME — NOT NULL
collection
- collection_id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- subcategory_id — INTEGER — Foreign key → subcategory.subcategory_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- en_name — VARCHAR(50)
- status_id — INTEGER — Foreign key → collection_status.status_id
- purchase_date — DATE
- purchase_place — VARCHAR(255)
- price — INTEGER
- storage_location — VARCHAR(255)
- post_date — DATETIME — NOT NULL
collection_board
- board_id — INTEGER — Foreign key → board.board_id — NOT NULL
- collection_id — INTEGER — Foreign key → collection.collection_id — NOT NULL
collection_photo
- photo_id — INTEGER — Primary key — NOT NULL
- collection_id — INTEGER — Foreign key → collection.collection_id — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- origin_filename — VARCHAR(255) — NOT NULL
collection_status
- status_id — INTEGER — Primary key — NOT NULL
- status_name — VARCHAR(255) — NOT NULL
comment
- comment_id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- board_id — INTEGER — Foreign key → board.board_id — NOT NULL
- content — TEXT — NOT NULL
- date — DATETIME — NOT NULL
- original_comment_id — INTEGER
- is_public — TINYINT — NOT NULL
forbidden_word
- word — VARCHAR(255) — Primary key — NOT NULL
google
- google_id — INTEGER — Primary key — NOT NULL
- google_name — VARCHAR(50) — NOT NULL
kakao
- kakao_id — INTEGER — Primary key — NOT NULL
- kakao_name — VARCHAR(50) — NOT NULL
likes
- board_id — INTEGER — Foreign key → board.board_id — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
maincategory
- maincategory_id — INTEGER — Primary key — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
naver
- naver_id — INTEGER — Primary key — NOT NULL
- naver_name — VARCHAR(50) — NOT NULL
report
- report_id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- report_content — TEXT — NOT NULL
- report_date — DATETIME — NOT NULL
- report_result_id — INTEGER — Foreign key → report_result_category.report_result_id
- result_content — TEXT
- report_category_id — INTEGER — Foreign key → report_category.report_category_id — NOT NULL
report_category
- report_category_id — INTEGER — Primary key — NOT NULL
- category_name — VARCHAR(255) — NOT NULL
report_result_category
- report_result_id — INTEGER — Primary key — NOT NULL
- result_name — VARCHAR(255) — NOT NULL
subcategory
- subcategory_id — INTEGER — Primary key — NOT NULL
- maincategory_id — INTEGER — Foreign key → maincategory.maincategory_id — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
trade_board
- board_id — INTEGER — Foreign key → board.board_id — NOT NULL
- collection_id — INTEGER — Foreign key → collection.collection_id
- price — INTEGER — NOT NULL
- status — TINYINT — NOT NULL
user
- user_id — INTEGER — Primary key — NOT NULL
- photo — VARCHAR(255)
- email — VARCHAR(40) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATE
- admin — TINYINT — NOT NULL
- sns_id — INTEGER — Foreign key → kakao.kakao_id
user_achievement
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- achievement_id — VARCHAR(50) — Foreign key → achievement.achievement_id — NOT NULL
- get_date — DATETIME — NOT NULL