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