MyProject

Tables (10)

Article (article)

  • 아이디 (article_id) — NUMBER — Primary key — NOT NULL
  • 제목 (article_title) — VARCHAR(128)
  • 작성자 (article_creator) — NUMBER — Foreign key → Member.아이디 — NOT NULL
  • 내용 (article_content) — VARCHAR(512)
  • 생성일 (article_createdAt) — DATETIME
  • 수정일 (article_updatedAt) — DATETIME

Article_Image (article_images)

  • 아이디 (article_images_id) — NUMBER — Primary key — NOT NULL
  • 게시물 (article_images_articleId) — NUMBER — Foreign key → Article.아이디 — NOT NULL
  • 이미지 (article_images_imagesId) — NUMBER — Foreign key → Image.아이디 — NOT NULL

ChatMessages (chatmessages)

  • 아이디 (chatmessages_id) — NUMBER — Primary key — NOT NULL
  • 내용 (chatmessages_content) — VARCHAR(512)
  • 보낸날짜 (chatmessages_sentAt) — DATETIME
  • 채팅방 (chatmessages_chatroom) — NUMBER — Foreign key → ChatRoom.아이디 — NOT NULL
  • 작성자 (chatmessages_sender) — NUMBER — Foreign key → Member.아이디 — NOT NULL

ChatRoom (chatrooms)

  • 아이디 (chatrooms_id) — NUMBER — Primary key — NOT NULL
  • 아이디 (chatrooms_plans) — NUMBER — Foreign key → Plans.아이디 — NOT NULL

Comments (comments)

  • 아이디 (comments_id) — NUMBER — Primary key — NOT NULL
  • 작성자 (comments_creator) — VARCHAR(256) — Foreign key → Member.아이디 — NOT NULL
  • 게시글 (comments_article) — NUMBER — Foreign key → Article.아이디 — NOT NULL
  • 내용 (comments_content) — VARCHAR(256)
  • 작성일 (comments_createdAt) — DATETIME
  • 수정일 (comments_updatedAt) — DATETIME

Image (images)

  • 아이디 (images_id) — NUMBER — Primary key — NOT NULL
  • 경로 (images_url) — VARCHAR(256)
  • 업로드일 (images_uploadedAt) — DATETIME
  • 파일크기 (images_size) — NUMBER
  • 파일명 (images_filename) — VARCHAR(256)

Member (member_tb)

  • 아이디 (member_id) — NUMBER — Primary key — NOT NULL
  • 로그인아이디 (member_loginId) — VARCHAR(256) — NOT NULL
  • 비밀번호 (member_pw) — VARCHAR(256) — NOT NULL
  • 이메일 (member_email) — VARCHAR(128) — NOT NULL
  • 이름 (member_name) — VARCHAR(256) — NOT NULL
  • 휴대폰번호 (member_phone) — NUMBER — NOT NULL
  • 국가 (member_country) — VARCHAR(128)
  • 닉네임 (member_nickname') — VARCHAR(128)
  • 관심사 (member_hobby) — VARCHAR(128)
  • mbti (member_mbti) — VARCHAR(128)
  • 가입일 (member_createdAt) — DATETIME — NOT NULL
  • 프로필 (member_profile) — NUMBER — Foreign key → Image.아이디 — NOT NULL

Participation (participation)

  • 아이디 (id) — NUMBER — Primary key — NOT NULL
  • 참여유저 (participation_user_id) — VARCHAR(256) — Foreign key → Member.아이디 — NOT NULL
  • 참여약속 (participation_plans_id) — NUMBER — Foreign key → Plans.아이디 — NOT NULL

Plans (plans)

  • 아이디 (plans_id) — NUMBER — Primary key — NOT NULL
  • 약속생성자 (plans_creator) — VARCHAR(256) — Foreign key → Member.아이디 — NOT NULL
  • 식당 (plans_restaurant) — NUMBER — Foreign key → Restaurant.번호 — NOT NULL
  • 참여일 (plans_joinedAt) — DATETIME
  • 참여정원 (plans_maxParticipants) — NUMBER
  • 메뉴 (plans_menu) — VARCHAR(256)
  • 이야기주제 (plans_talkingTopic) — VARCHAR(256)
  • 생성일 (plans_createAt) — DATETIME
  • 모집상태 (plans_status) — VARCHAR(256)

Restaurant (restaurant)

  • 번호 (restaurant_id) — NUMBER — Primary key — NOT NULL
  • 식당이름 (restaurant_name) — VARCHAR(256)
  • 주소 (restaurant_address) — VARCHAR(256)
  • 평점 (restaurant_rating) — NUMBER