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)