project1
테이블 (7)
게시판 (board)
- board_seq_no — INT
- user_seq_no — INT — NOT NULL
- board_gubun — ENUM('gongji','diary')
- board_title — VARCHAR(200)
- board_content — TEXT
- board_view — INT
- board_create_date — DATETIME
- board_update_date — DATETIME
- board_delete_check — ENUM('Y','N')
다이어리 (diary)
- user_seq_no (user_seq_no2) — NOT NULL — 외래 키 → 회원정보.user_seq_no — NOT NULL
- diary_seq_no — INT
- user_seq_no — INT — NOT NULL
- trip_title — VARCHAR(200)
- diary_title — VARCHAR(200)
- diary_content — TEXT
- diary_tags — JSON
- diary_frame_file — INT
- diary_status — ENUM('public','private','framed')
- diary_create_date — DATETIME
- diary_update_date — DATETIME
댓글 (comment)
- comment_seq_no — INT
- board_seq_no — INT — NOT NULL
- user_seq_no — INT — NOT NULL
- comment_content — VARCHAR(500)
- comment_create_date — DATETIME
- comment_update_date — DATETIME
- comment_delete_check — ENUM('Y','N')
미션 (mission)
- mission_seq_no — INT
- user_seq_no — INT — NOT NULL
- mission_name — VARCHAR(100)
- mission_detail — TEXT
- mission_type — ENUM('random','location','game','photo') — NOT NULL
- mission_reward — INT
- mission_status — ENUM('pending','done','failed','expired')
- mission_lat — DOUBLE
- mission_lng — DOUBLE
- mission_create_date — DATETIME
- mission_update_date — DATETIME
채팅 (chat)
- chat_seq_no — INT
- user_seq_no — INT — NOT NULL
- chat_type — ENUM('user-ai','mission','friend') — NOT NULL
- session_id — VARCHAR(100)
- chat_message — TEXT — NOT NULL
- chat_metadata — JSON
- chat_create_date — DATETIME
파일 (file)
- file_seq_no — INT
- file_name — TEXT
- file_extension — VARCHAR(10)
- file_target_type — ENUM('board','mission','diary','profile','frame','log') — NOT NULL
- file_target_seq — INT — NOT NULL
- file_create_date — DATETIME
회원정보 (user)
- user_seq_no — NOT NULL — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- user_pw — VARCHAR(255) — NOT NULL
- user_nickname — VARCHAR(50) — NOT NULL
- user_email — VARCHAR(100) — NOT NULL
- user_birth — DATE
- user_theme_hate — VARCHAR(200)
- user_food_hate — VARCHAR(200)
- user_region_hate — VARCHAR(200)
- user_addr1 — VARCHAR(100)
- user_addr2 — VARCHAR(100)
- user_create_date — DATETIME
- user_update_date — DATETIME
- user_delete_check — ENUM('Y','N')