Green

테이블 (8)

Exchange (Untitled3)

  • pro_num (PK) — 기본 키 — NOT NULL
  • pro_title (Field)
  • pro_price (Field2)
  • pro_img (Field3)
  • pro_content (Field4)

Image (Untitled8)

  • img_num (PK) — 기본 키 — NOT NULL
  • pick_num (FK)
  • img_title (Field)
  • img_path (Field2)
  • pick_num (PK2) — 외래 키 → Pickup.pick_num — NOT NULL

MyPage (Untitled4)

  • Key — 기본 키 — NOT NULL
  • Field

Pickup (Untitled2)

  • pick_num (PK) — 기본 키 — NOT NULL
  • user_num (FK)
  • address (Field2)
  • zip_code (Field3)
  • house (Field4)
  • elevator (Field9)
  • pick_date (Field)
  • memo (Field5)
  • category (Field6)
  • img_exist (Field8)
  • user_num (PK2) — 외래 키 → User.user_num — NOT NULL

User (Untitled)

  • user_num (PK) — 기본 키 — NOT NULL
  • user_pass (Field2)
  • user_id (Field)
  • address1 (Field3)
  • zip_code (Field4)
  • user_email (Field5)
  • user_phone (Field6)
  • user_name (Field7)
  • user_point (Field8)

comment (Untitled7)

  • commnet_num (PK) — 기본 키 — NOT NULL
  • Field

notice(공지사항) (Untitled5)

  • no_num (PK) — 기본 키 — NOT NULL
  • no_title (Field)
  • no_content (Field2)
  • user_id (Field3)
  • no_date (Field4)

qna(질의사항) (Untitled6)

  • qna_num (PK) — 기본 키 — NOT NULL
  • qna_title (Field)
  • qna_contents (Field2)
  • user_id (Field3)
  • qna_date (Field4)
  • commnet (Field5)