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