Karrot

Tables (7)

ChatMsg (Untitled7)

  • c_id (Key) — Primary key — NOT NULL
  • r_id (Key2) — Foreign key → ChatRoom.r_id — NOT NULL
  • i_id (Key3) — Foreign key → Item.i_id — NOT NULL
  • c_sender (Field)
  • c_msg (Field2)

ChatRoom (Untitled6)

  • r_id (Key) — Primary key — NOT NULL
  • i_id (Key2) — Foreign key → Item.i_id — NOT NULL
  • m_id (Key3) — Foreign key → Member.m_id — NOT NULL

Item (Untitled2)

  • i_id (Key) — Primary key — NOT NULL
  • m_id (Key2) — Foreign key → Member.m_id — NOT NULL
  • m_img_id (Key22) — Foreign key → Member.m_img_id — NOT NULL
  • i_title (Field) — 제목
  • i_cate (Field2)
  • i_price (Field3)
  • i_content (Field4)
  • i_time (Field5)
  • i_like (Field6)
  • i_status (Field7)

Item_Img (Untitled3)

  • i_img_id (Key) — Primary key — NOT NULL
  • i_id (Key2) — Foreign key → Item.i_id — NOT NULL
  • m_img_id (Key22) — Foreign key → Item.m_img_id — NOT NULL
  • img_name (Field)
  • ori_img_name (Field2)
  • img_url (Field3)
  • rep_img_yn (Field4)

LikeItem (Untitled4)

  • l_id (Key) — Primary key — NOT NULL
  • m_id (Key2) — Foreign key → Member.m_id — NOT NULL
  • i_id (Key3) — Foreign key → Item.i_id — NOT NULL

Member (Untitled)

  • m_id (Key) — Primary key — NOT NULL
  • m_img_id (Key2) — Foreign key → Member_Img.m_img_id — NOT NULL
  • email (Field) — NOT NULL
  • name (Field2)
  • password (Field3)
  • nick (Field4)
  • phone (Field5)

Member_Img (Untitled5)

  • m_img_id (Key) — Primary key — NOT NULL
  • img_name (Field)
  • ori_img_name (Field2)
  • img_url (Field3)