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)