당근

테이블 (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)