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)