Mypet

Tables (6)

Untitled (boards)

  • Key (no) — NUMBER — Primary key — NOT NULL
  • id (writer) — VARCHAR2(50) — Foreign key → member.id — NOT NULL
  • Field (board_type) — VARCHAR2(50) — NOT NULL
  • Field3 (title) — VARCHAR2(200) — NOT NULL
  • Field4 (content) — VARCHAR2(4000) — NOT NULL
  • Field5 (file_path) — VARCHAR2(300)
  • Field6 (file_name) — VARCHAR2(300)
  • Field7 (groupno) — NUMBER
  • Field8 (orderno) — NUMBER
  • Field9 (depth) — NUMBER
  • Field10 (reads_count) — NUMBER
  • Field11 (likes_count) — NUMBER
  • Field12 (created_at) — DATE

Untitled (comments)

  • Key (c_no) — NUMBER — Primary key — NOT NULL
  • Key (b_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (writer) — VARCHAR2(50) — NOT NULL
  • Field (content) — VARCHAR2(1000) — NOT NULL
  • Field (created_at) — DATE

Untitled (products)

  • Key (p_id) — NUMBER — Primary key — NOT NULL
  • Field (p_type) — VARCHAR2(100) — NOT NULL
  • Field (category) — VARCHAR2(50) — NOT NULL
  • Field (name) — VARCHAR2(100) — NOT NULL
  • Field (price) — NUMBER — NOT NULL
  • Field (stock) — NUMBER — NOT NULL
  • Field (file_path) — VARCHAR2(500)
  • Field (file_name) — VARCHAR2(500)
  • Field (content) — VARCHAR2(4000) — NOT NULL
  • Field (p_point) — NUMBER — NOT NULL
  • Field (sell_counts) — NUMBER
  • Field (discount_rate) — NUMBER
  • Field (created_at) — DATE — NOT NULL

Untitled (orders)

  • Key (o_id) — NUMBER — Primary key — NOT NULL
  • id (m_id) — VARCHAR2(20) — Foreign key → member.id — NOT NULL
  • Field (name) — VARCHAR2(30) — NOT NULL
  • Field (phone) — VARCHAR2(50) — NOT NULL
  • Field (zipcode) — VARCHAR2(20) — NOT NULL
  • Field (address1) — VARCHAR2(500) — NOT NULL
  • Field (address2) — VARCHAR2(500) — NOT NULL
  • Field (order_date) — DATE — NOT NULL

Untitled (order_details)

  • Key (oo_id) — NUMBER — Primary key — NOT NULL
  • Key (o_id) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (p_num) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (qty) — NUMBER — NOT NULL
  • Field (remark) — VARCHAR2(200)

member

  • id — VARCHAR2(40) — Primary key — NOT NULL
  • name — VARCHAR2(30) — NOT NULL
  • Field (nickname) — VARCHAR2(50) — NOT NULL
  • Field (password) — VARCHAR2(40) — NOT NULL
  • Field2 (email) — VARCHAR2(100) — NOT NULL
  • Field3 (phone) — VARCHAR2(50) — NOT NULL
  • Field4 (zipcode) — VARCHAR2(20) — NOT NULL
  • Field5 (address1) — VARCHAR2(300) — NOT NULL
  • Field (address2) — VARCHAR2(300) — NOT NULL
  • Field (animal_type) — VARCHAR2(50) — NOT NULL
  • Field (mpoint) — NUMBER
  • Field (mlevel) — NUMBER
  • Field (created_at) — DATE
  • Field (STATUS) — NUMBER