당근
테이블 (13)
Copy Of Member (member_deal)
- Key (no) — number — 기본 키 — NOT NULL
- Key (product_no) — number — 외래 키 → Untitled.Key — NOT NULL
- id (seller_id) — varchar2(50) — 외래 키 → Member.id — NOT NULL
- Field (buyer_id) — varchar2(50)
- Field4 (deal_status) — number
- Field5 (deal_date) — date
Copy Of Untitled (town_board_category)
- Key (no) — number — 기본 키 — NOT NULL
- Field (category_name) — varchar2(50)
Member (member)
- id — varchar2(50) — 기본 키 — NOT NULL
- Field2 (pw) — varchar2(30)
- Field (name) — varchar2(15)
- Field3 (gender) — varchar2(6)
- Field4 (phone_number) — varchar2(50)
- Field5 (email) — varchar2(100)
- Field (address) — varchar2(120)
- Field (address1) — varchar2(40)
- Field (address2) — varchar2(40)
- Field (address3) — varchar2(40)
- Field (image) — varchar2(100)
- Field (member_status) — number
- Field (authority) — number
- Field (report_count) — number
- Field2 (site_status) — number
Untitled (manner_temp)
- id — varchar2(50) — 외래 키 → Member.id — NOT NULL
- Field (manner_temp) — number
Untitled (product)
- Key (no) — number — 기본 키 — NOT NULL
- Field2 (seller_id) — varchar2(50)
- Field (subject) — varchar2(250)
- Key (category) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (address) — varchar2(120)
- Field (adress1) — varcahr2(40)
- Field2 (address2) — varcahr2(40)
- Field3 (address3) — varcahr2(40)
- Field (contents) — varchar2(250)
- Field (price) — number
- Field (refund_availability) — number
- Field (reg_date) — date
- Field (deal_status) — number
- Field (readcount) — number
- Field (image1) — varchar2(100)
Untitled (product_like)
- Key (no) — number — 기본 키 — NOT NULL
- Key (product_no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field2 (user_id) — varchar2(50)
Untitled (product_keyword)
- Key (no) — number — 기본 키 — NOT NULL
- Field (keyword) — varchar2(50)
- Field (count) — number
Untitled (town_board_like)
- Key (no) — number — 기본 키 — NOT NULL
- Field (town_board_no) — number
- Key (user_id) — varchar2(50) — 외래 키 → Untitled.Key — NOT NULL
Untitled (product_category)
- Key (no) — number — 기본 키 — NOT NULL
- Field (category_name) — varchar2(50)
Untitled (member_deal_review)
- Key (no) — number — 기본 키 — NOT NULL
- Field (product_no) — number
- id (seller_id) — varchar2(50) — 외래 키 → Member.id — NOT NULL
- Field (buyer_id) — varchar2(50)
- Field (contents) — varchar2(250)
- Field2 (rating) — int
- Field (reg_date) — date
Untitled (town_board)
- Key (no) — number — 기본 키 — NOT NULL
- id (writer) — varchar2(50) — 외래 키 → Member.id — NOT NULL
- Field2 (address1) — varchar2(20)
- Field (address2) — varchar2(20)
- Field (subject) — varchar2(250)
- Key (category) — number — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Field (contents) — varchar2(250)
- Field (ref) — number
- Field (re_level) — number
- Field (re_step) — number
- Field (reg_date) — date
- Field (readcount) — number
Untitled (product_file)
- Key (no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (pno) — umber
- Field (filename) — varchar2(100)
Untitled (town_board_file)
- Key (no) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (bno) — number
- Field2 (filename)