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)