내꺼도

테이블 (8)

거래 (deal)

  • Deal Id (deal_id) — bigint — 기본 키 — NOT NULL
  • Chatting Main Id (chatmain_id2) — bigint — 외래 키 → 채팅메인.Chatting Main Id — NOT NULL
  • Registration Date (reg_date) — datetime
  • User id (user_id) — varchar(255) — 외래 키 → 회원.User id — NOT NULL — 작성자

게시글 (report)

  • Report Id (report_id) — bigint — 기본 키 — NOT NULL
  • Report Content (contents) — varchar(255)
  • Registration Date (reg_date) — datetime
  • Type (type) — varchar(255)
  • User id (user_id) — varchar(255) — 외래 키 → 회원.User id — NOT NULL — 작성자

채팅메인 (chatmain)

  • Chatting Main Id (chatmain_id) — bigint — 기본 키 — NOT NULL
  • Address (address) — varchar(225) — 외래 키 → 회원.User id — NOT NULL — 작성자
  • Bookmarks (bookmarks) — varchar(225) — NOT NULL
  • Bookmarks Date (bookmarks_date) — datetime — NOT NULL
  • Category (category) — varchar(225) — NOT NULL
  • Create Date (create_date) — datetime
  • End Date (end_date) — datetime
  • Img Path (img_path) — varchar(225) — NOT NULL — check
  • Link (link) — varchar(225)
  • Max Count (max_count) — int
  • Order Time Type (order_time_type) — varchar(225) — NOT NULL
  • Place (place) — varchar(225)
  • State (state) — varchar(225)
  • Title (title) — varchar(225)
  • User Id (user_id) — varchar(225)

채팅상세 (Chat_Detail)

  • Chatting Detail Id (chatdetail_id) — bigint — 기본 키 — NOT NULL
  • User Id (user_id) — varchar(255) — 외래 키 → 회원.User id — NOT NULL — 작성자
  • Chatting Main Id (chatmain_id) — bigint — 외래 키 → 채팅메인.Chatting Main Id — NOT NULL
  • Contents (contents) — longtext — NOT NULL — check
  • Registration Date (reg_date) — datetime — 방장이
  • Type (type) — varchar(255)

채팅참여 유저 (chat_user)

  • Catting User Id (chat_user_id) — bigint — 기본 키 — NOT NULL
  • Ban State (ban_state) — varchar(225)
  • Enter Date (enter_date) — datetime
  • Chatting Main Id (chatmain_id) — bigint — 외래 키 → 채팅메인.Chatting Main Id — NOT NULL
  • Session Id (session_id) — varchar(225)
  • State (state) — varchar(225)
  • User id (user_id2) — varchar(255) — 외래 키 → 회원.User id — NOT NULL — 작성자

퀵챗 (quick_chat)

  • QuickChatting ID (quick_chat_id) — bigint — 기본 키 — NOT NULL
  • 1st Message (msg1) — varchar(255)
  • 2nd Message (msg2) — varchar(255)
  • 3rd Message (msg3) — varchar(255)
  • 4th Message (msg4) — varchar(255)
  • 5th Message (msg5) — varchar(255)

태그 (tag)

  • Tag Id (tag_id) — bigint — 기본 키 — NOT NULL
  • Name (name) — varchar(255)
  • Chatting Main Id (chatmain_id) — bigint — 외래 키 → 채팅메인.Chatting Main Id — NOT NULL

회원 (Users)

  • User id (user_id) — varchar(255) — 기본 키 — NOT NULL — 작성자
  • Address (address) — varchar(255)
  • Authority (authority) — varchar(255) — NOT NULL
  • Building Code (building_code) — varchar(255) — NOT NULL
  • Email (user_nickname) — varchar(255) — NOT NULL
  • Profile Image Path (imgpath) — varchar(255) — NOT NULL
  • Join Date (joindate) — datetime
  • Nickname (nickname) — varchar(255) — NOT NULL — check
  • Password (password) — varchar(255) — NOT NULL — Check
  • Phone number (phone) — varchar(255)
  • Social Id (social_id) — varchar(255)
  • Withdrawal_date (withdrawal_date) — datetime
  • Zone Code (zonecode) — varchar(255)
  • QuickChatting ID (quick_chat_id2) — bigint — 외래 키 → 퀵챗.QuickChatting ID — NOT NULL — 1:N 관계