Harusekki ERD
Tables (15)
Article (Untitled9)
- 게시물id (article_id) — INT — Primary key — NOT NULL
- 유저id (uid) — INT — Foreign key → User.유저id — NOT NULL
- 게시물 이미지 (article_image) — BLOB
- 게시물 내용 (article_content) — VARCHAR(255))
- 게시물 생성시간 (created_at) — DATE
- 게시물 수정시간 (updated_at) — DATE
- 좋아요 수 (num_of_like) — INT
Article_Images (Untitled14)
- id — INT — Primary key — NOT NULL
- 게시물id (article_id) — INT — Foreign key → Article.게시물id — NOT NULL
- 이미지id (id2) — INT — Foreign key → Gallery.이미지id — NOT NULL
- 유저id (uid) — INT — Foreign key → Gallery.유저id — NOT NULL
- 이미지 uri (image) — VARCHAR(45)
Comment (Untitled10)
- 댓글id (comment_id) — INT — Primary key — NOT NULL
- 게시물id (article_id) — INT — Foreign key → Article.게시물id — NOT NULL
- 작성자id (comment_uid) — INT
- 댓글내용 (comment_content) — VARCHAR(255)
- 댓글 생성시간 (created_at) — DATE
- 댓글 수정시간 (updated_at) — DATE
FollowingTable (Untitled3)
- 내 id (following_id) — INT — Foreign key → User.유저id — NOT NULL
- 상대 id (follower_id) — INT
- 팔로우 여부 (is_follow) — BOOLEAN
Food (Untitled5)
- 음식id (food_id) — INT — Primary key — NOT NULL
- 음식이름 (food_name) — VARCHAR(45)
- 1회제공량 (one_time_supply) — FLOAT
- 탄수화물 (carbohydrate) — FLOAT
- 단백질 (protein) — FLOAT
- 지방 (fat) — FLOAT
- 당류 (sugar) — FLOAT
- 나트륨 (sodium) — FLOAT
- 콜레스테롤 (cholesterol) — FLOAT
- 포화지방산 (saturated_fatty_acid) — FLOAT
- 트랜스지방 (trans_fats) — FLOAT
Food_In_Image (Untitled4)
- id — INT — Primary key — NOT NULL
- 이미지id (image_id) — INT — Foreign key → Gallery.유저id — NOT NULL
- 음식id (food_id) — INT — Foreign key → Food.음식id — NOT NULL
- 음식의 양 (value) — INT
- 음식 좌표 (location) — VARCHAR(45)
Foods_and_Recipt (Untitled6)
- id — INT — Primary key — NOT NULL
- id (id2) — INT — Foreign key → Article_Images.id — NOT NULL
- 게시물id (article_id) — INT — Foreign key → Article_Images.게시물id — NOT NULL
- 이미지id (id22) — INT — Foreign key → Article_Images.이미지id — NOT NULL
- 유저id (uid) — INT — Foreign key → Article_Images.유저id — NOT NULL
- 음식id (food_id) — INT — Foreign key → Food.음식id — NOT NULL
- 음식 (food) — VARCHAR(45)
- 레시피 (Field) — VARCHAR(255)
Gallery (Untitled2)
- 이미지id (id) — INT — Primary key — NOT NULL
- 유저id (uid) — INT — Foreign key → User.유저id — NOT NULL
- 이미지uri (image) — VARCHAR(45)
- 식사 시간 (mealTime) — VARCHAR(45)
- 생성시간 (created_at) — DATE
Hash (Untitled8)
- 해쉬id (hash_id) — INT — Primary key — NOT NULL
- 해쉬명 (hash_name) — VERCHAR(45)
Hash_in_Article
- id — INT — Primary key — NOT NULL
- 게시물id (article_id) — INT — Foreign key → Article.게시물id — NOT NULL
- 해쉬id (hash_id) — INT — Foreign key → Hash.해쉬id — NOT NULL
Like_User (Untitled15)
- id — INT — Primary key — NOT NULL
- 게시물id (article_id) — INT — Foreign key → Article.게시물id — NOT NULL
- 좋아요한 유저id (uid) — INT — Foreign key → User.유저id — NOT NULL
Message (Untitled13)
- 메세지 id (id) — Primary key — NOT NULL
- 대화상대 id (Key) — INT — Foreign key → Opponent.대화상대 id — NOT NULL
- 내용 (content) — VARCHAR(45)
- 전송 시간 (created_at) — DATE
- 발신수신 여부 (isSend) — BOOLEAN
Opponent (Untitled12)
- 대화상대 id (Key) — INT — Primary key — NOT NULL
- 유저id (userId) — INT — Foreign key → User.유저id — NOT NULL
- 상대방 userid (yourId) — INT
- 마지막 메시지 시각 (last_time) — DATE
- 읽지 않은 메세지 갯수 (not_read_cnt) — INT
Reply (Untitled11)
- 답글id (reply_id) — INT — Primary key — NOT NULL
- 댓글id (comment_id) — INT — Foreign key → Comment.댓글id — NOT NULL
- 작성자id (reply_uid) — INT
- 덧글내용 (reply_content) — VARCHAR(255)
- 덧글 생성시간 (created_at) — DATE
- 덧글 수정시간 (updated_at) — DATE
User (Untitled)
- 유저id (id) — INT — Primary key — NOT NULL
- 이메일 (email) — VARCHAR(45)
- 닉네임 (username) — VARCHAR(45)
- 비밀번호 (password) — VARCHAR(45)
- 키 (height) — INT
- 몸무게 (weight) — INT
- 나이 (age) — INT
- 활동량 (active) — VARCHAR(45)
- 성별 (sex) — VARCHAR(45)
- 기초대사량 (basal_metabolism) — INT
- 프로필이미지 uri (profileImage) — VARCHAR(45)