i
Tables (23)
Auto_login
- Key (aul_idx) — BIGINT — Primary key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- Field (aul_key) — TEXT
- Field (aul_created_time) — DATETIME
Blame
- Key (blame_idx) — BIGINT — Primary key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- Field (target_mem_idx) — BIGINT
- Field (target_idx) — BIGINT
- Field (target_type) — INT
- Field (blame_content) — TEXT
- Field (blame_time) — DATETIME
Chatting
- Key (chat_idx) — BIGINT — Primary key — NOT NULL
- Key (room_idx) — BIGINT — Foreign key → Chatting_room.Key — NOT NULL
- Field (mem_send_idx) — BIGINT
- Field (chat_content) — TEXT
- Field (chat_image) — INT
- Field (chat_time) — DATETIME
- Field (chat_read) — CHAR(1)
Chatting_notification
- Key (cn_idx) — BIGINT — Primary key — NOT NULL
- Key (room_idx) — BIGINT — Foreign key → Chatting_room.Key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- Field (cn_status) — CHAR(1)
Chatting_room
- Key (room_idx) — BIGINT — Primary key — NOT NULL
- Field (mem1_idx) — BIGINT
- Field (mem2_idx) — BIGINT
- Field (room_created_at) — DATETIME
- Field (room_recent_time) — DATETIME
- Field (room_quit1) — CHAR(1)
- Field (room_quit1_time) — DATETIME
- Field (room_quit2) — CHAR(1)
- Field (room_quit2_time) — DATETIME
Complain
- Key (complain_idx) — BIGINT — Primary key — NOT NULL
- Field (complain_title) — VARCHAR(255)
- Field (complain_content) — TEXT
- Field (complain_email) — VARCHAR(100)
- Field (status) — CHAR(1)
- Field (created_at) — DATETIME
Diary_comment (Dairy_comment)
- Key (diary_cmt_idx) — BIGINT — Primary key — NOT NULL
- Key (diary_idx) — BIGINT — Foreign key → Diary_feed.Key — NOT NULL
- Field (mem_idx) — BIGINT
- Field (mem_nickname) — VARCHAR(12)
- Field (diary_parent_idx) — BIGINT
- Field (diary_cmt_content) — TEXT
- Field (diary_cmt_created_at) — DATETIME
Diary_feed (Dairy_feed)
- Key (diary_idx) — BIGINT — Primary key — NOT NULL
- Field (mem_idx) — BIGINT
- (mem_nickname) — VARCHAR(12)
- Field (diary_roomType) — CHAR(1)
- Field (diary_title) — VARCHAR(255)
- Field (diary_content) — TEXT
- Field (diary_image) — UNSIGNED INT
- (diary_hit) — UNSIGNED INT
- Field (diary_comment_count) — UNSIGNED INT
- Field (diary_like_count) — UNSIGNED INT
- Field (diary_blame) — UNSIGNED INT
- Field (diary_created_at) — DATETIME
- Field (diary_delete) — CHAR(1)
Diary_feed_like
- Key (dfl_idx) — BIGINT — Primary key — NOT NULL
- Key (diary_idx) — BIGINT — Foreign key → Diary_feed.Key — NOT NULL
- Field (mem_idx) — BIGINT
- Field (dfl_status) — CHAR(1)
Diary_feed_notification
- Key (dfn_idx) — BIGINT — Primary key — NOT NULL
- Key (diary_idx) — BIGINT — Foreign key → Diary_feed.Key — NOT NULL
- Field (mem_idx) — BIGINT
- Field (dfn_status) — CHAR(1)
Image_url
- Key (image_idx) — BIGINT — Primary key — NOT NULL
- 게시판 종류 (content_category) — UNSIGNED INT
- Field (content_idx) — BIGINT
- Field (image_url) — TEXT
- Field (image_order) — UNSIGNED INT
Market
- 게시물 고유번호 (market_idx) — BIGINT — Primary key — NOT NULL
- 게시물 작성자 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- 게시물 카테고리 (market_group) — INT
- 거래 품목 (market_goods) — BIGINT
- 거래 가격 (market_price) — UNSIGNED INT
- 게시글 제목 (market_title) — VARCHAR(255)
- 게시물 내용 (market_content) — TEXT
- 게시물 이미지 개수 (market_image) — UNSIGNED INT
- 거래 완료 여부 (market_soldout) — CHAR(1)
- 게시물 신고 수 (market_blame) — UNSIGNED INT
- 게시물 조회수 (market_hit) — UNSIGNED INT
- 게시물 좋아요 수 (market_like_count) — UNSIGNED INT
- 게시물 작성일자 (market_created_at) — DATETIME
Market_like
- 고유번호 (ml_idx) — BIGINT — Primary key — NOT NULL
- 게시물 고유번호 (market_idx) — BIGINT — Foreign key → Market.게시물 고유번호 — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- ml_status — CHAR(1)
- 회원 고유번호 (mem_idx22) — BIGINT — Foreign key → Market.게시물 작성자 회원 고유번호 — NOT NULL
Market_review
- 게시물 고유번호 (review_idx) — BIGINT — Primary key — NOT NULL
- 게시물 고유번호 (market_idx) — BIGINT — Foreign key → Market.게시물 고유번호 — NOT NULL
- 판매회원 고유번호 (sell_mem_idx) — BIGINT — Foreign key → Market.게시물 작성자 회원 고유번호 — NOT NULL
- 구매회원 고유번호 (게시물 작성자) (buy_mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- 게시물 내용 (review_content) — TEXT
- 게시물 이미지 개수 (review_image) — UNSIGNED INT
- 게시물 조회수 (review_hit) — UNSIGNED INT
- 게시물 신고 수 (review_blame) — UNSIGNED INT
- 게시물 작성일자 (review_created_at) — DATETIME
Member
- 회원 고유번호 (mem_idx) — BIGINT — Primary key — NOT NULL
- 회원 이메일 (mem_email) — VARCHAR(100)
- 회원 비밀번호 (mem_password) — TEXT
- 회원 전화번호 (mem_phone) — VARCHAR(15)
- 회원 닉네임 (mem_nickname) — VARCHAR(12)
- 회원 프로필 소개 (mem_profile_content) — VARCHAR(255)
- 회원 프로필 이미지 (mem_profile_url) — TEXT
- 회원 생년월일 (mem_birth) — DATE
- 회원 우편번호 (mem_address_code) — CHAR(6)
- 회원 주소1 (mem_address) — VARCHAR(510)
- 회원 주소2 (mem_address_detail) — VARCHAR(255)
- 회원 알림설정 (mem_noti) — CHAR(1)
- 회원 가입일자 (mem_created_at) — DATETIME
- 회원 최종 업데이트 (mem_updated_at) — DATETIME
Member_auth
- (ma_idx) — BIGINT — Primary key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- ma_key — CHAR(6)
- Field (ma_type) — CHAR(1)
- 인증번호 발급시간 (ma_generate_time) — DATETIME
- Field (ma_used_time) — DATETIME
- Field (ma_expired) — CHAR(1)
Member_block
- Key (mb_idx) — BIGINT — Primary key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- Field (blocked_mem_idx) — BIGINT
- Field (block_time) — DATETIME
Member_withdraw
- 회원 고유번호 (mem_idx) — BIGINT — Primary key — NOT NULL
- 회원 이메일 (mem_email) — VARCHAR(100)
- 회원 전화번호 (mem_phone) — VARCHAR(15)
- 회원 닉네임 (mem_nickname) — VARCHAR(12)
- (mw_time) — DATETIME
Notification
- 알림 고유번호 (not_idx) — BIGINT — Primary key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- 알림 카테고리 (not_type) — UNSIGNED INT
- (not_content_idx) — BIGINT
- 알림 메시지 (not_message) — TEXT
- Field (not_time) — DATETIME
- Field (not_read) — DATETIME
Story_fee_notification (Story_feed_notification)
- Key (sfn_idx) — BIGINT — Primary key — NOT NULL
- Key (story_idx) — BIGINT — Foreign key → Story_feed.Key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- Field (sfn_status) — CHAR(1)
Story_feed
- Key (story_idx) — BIGINT — Primary key — NOT NULL
- Field (story_roomType) — CHAR(1)
- Field (story_title) — VARCHAR(255)
- Field (story_content) — TEXT
- Field (story_image) — UNSIGNED INT
- Field (story_hit) — UNSIGNED INT
- Field (story_comment_count) — UNSIGNED INT
- Field (story_like_count) — UNSIGNED INT
- Field (story_created_at) — DATETIME
- Field (story_delete) — CHAR(1)
- Field (stroy_blame) — BIGINT
Story_feed_comment
- Key (story_cmt_idx) — BIGINT — Primary key — NOT NULL
- Key (story_idx) — BIGINT — Foreign key → Story_feed.Key — NOT NULL
- Field (mem_idx) — BIGINT
- Field (mem_nickname) — VARCHAR(12)
- Field (story_parent_idx) — BIGINT
- Field (story_cmt_content) — TEXT
- Field (sotry_cmt_created_at) — DATETIME
Story_feed_like
- Key (sfl_idx) — BIGINT — Primary key — NOT NULL
- Key (story_idx) — BIGINT — Foreign key → Story_feed.Key — NOT NULL
- 회원 고유번호 (mem_idx) — BIGINT — Foreign key → Member.회원 고유번호 — NOT NULL
- Field (sfl_status) — CHAR(1)