dfd
Tables (13)
board (게시글)
- board_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- category_id — INT — Foreign key → board_category.board_category_id — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — VARCHAR(4000) — NOT NULL
- like_count — INT — NOT NULL
- view_count — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- address — VARCHAR(255)
- delete_whether — CHAR(9) — NOT NULL
board_category (게시글 카테고리)
- board_category_id — INT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
board_img (게시글 이미지)
- board_img_id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
- path — VARCHAR(100) — NOT NULL
- system_name — VARCHAR(300) — NOT NULL
- origin_name — VARCHAR(255) — NOT NULL
- main_whether — CHAR(1) — NOT NULL
body_record (신체기록)
- body_record_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE — NOT NULL
- bodyCondition — VARCHAR(50) — NOT NULL
- weight — DECIMAL(5,2) — NOT NULL
- skeletal_muscle — DECIMAL(5,2)
- content — VARCHAR(500) — NOT NULL
- body_fat — INT
- img — VARCHAR(330)
chat_history (채팅기록)
- chat_history_id — INT — Primary key — NOT NULL
- chat_room_id — INT — Foreign key → chat_room.chat_room_id — NOT NULL
- send_user_id — INT — Foreign key → user.user_id — NOT NULL
- message — VARCHAR(1000) — NOT NULL
- send_date — TIMESTAMP — NOT NULL
chat_room (채팅방)
- chat_room_id — INT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- last_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
chat_room_user (채팅방 회원)
- chat_room_user_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- chat_room_id — INT — Foreign key → chat_room.chat_room_id — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
like (좋아요)
- like_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- entity_type — VARCHAR(10) — NOT NULL
- entity_id — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- delete_whether — CHAR(9) — NOT NULL
meal (식단)
- meal_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- date — DATE — NOT NULL
- type — CHAR(10) — NOT NULL
- kcal — INT — NOT NULL
- protein — INT
- fat — INT
- carbs — INT
meal_record (식단기록)
- meal_record_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE — NOT NULL
- type — CHAR(6) — NOT NULL
- img — VARCHAR(330)
- meal_time — VARCHAR(20)
- content — VARCHAR(500) — NOT NULL
- fullness — VARCHAR(30) — NOT NULL
meal_streak (식단스트릭)
- meal_streak_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- streak — INT — NOT NULL
- morning — TINYINT(1)
- lunch — TINYINT(1)
- dinner — TINYINT(1)
- date — TIMESTAMP — NOT NULL
reply (댓글)
- reply_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
- parent_reply_id — INT — Foreign key → reply.reply_id — NOT NULL
- content — VARCHAR(1000)
- depth — INT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user (회원)
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(320) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- profile_url — VARCHAR(330)
- phone — VARCHAR(13)
- post_code — CHAR(5) — NOT NULL
- parcel_address — VARCHAR(50) — NOT NULL
- street_address — VARCHAR(100) — NOT NULL
- detail_address — VARCHAR(100)
- refresh_token — VARCHAR(600)
- latitude — DECIMAL(9,6) — NOT NULL
- longitude — DECIMAL(9,6) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- status — TINYINT(1) — NOT NULL
- role — VARCHAR(10) — NOT NULL