내꺼도
테이블 (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 관계