Mypet
Tables (10)
boards
- id — number — Primary key — NOT NULL
- user_id — number — Foreign key → users.id — NOT NULL
- group_id — number — NOT NULL
- seq — number — NOT NULL
- depth — number — NOT NULL
- board_type — enum("normal", "qna", "post", "review") — NOT NULL
- title — varchar2(255) — NOT NULL
- content — text — NOT NULL
- reads_count — number — NOT NULL
- likes_count — number — NOT NULL
- comments_count — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
categories (Untitled4)
- id — number — Primary key — NOT NULL
- parent_id — number
- name — varchar2(255) — NOT NULL
- position — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
comments (Untitled2)
- id — number — Primary key — NOT NULL
- user_id — number — Foreign key → users.id — NOT NULL
- context_type — varchar2(255) — NOT NULL
- context_id — number — NOT NULL
- content — text — NOT NULL
- likes_count (likes_counnt) — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
likes (Untitled)
- id — number — Primary key — NOT NULL
- user_id — number — Foreign key → users.id — NOT NULL
- context_type — varchar2(255) — NOT NULL
- context_id — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
order_product_options (CopyOfUntitled6)
- id — number — Primary key — NOT NULL
- order_id — number — Foreign key → orders.id — NOT NULL
- product_option_id — number — Foreign key → product_options.id — NOT NULL
- count — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
orders (Untitled8)
- id — number — Primary key — NOT NULL
- user_id — number — Foreign key → users.id — NOT NULL
- parcel_charge — number — NOT NULL
- total_price — number — NOT NULL
- total_quantity — number — NOT NULL
- status — enum("cart", "order", "canceled", "ready_to_delivery", "delivery", "done_delivery", "complete") — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
product_options (Untitled7)
- id — number — Primary key — NOT NULL
- product_id — number — Foreign key → products.id — NOT NULL
- option — varchar2(255) — NOT NULL
- size — varchar2(255)
- stock — number — NOT NULL
- sell_count — number — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
products (Untitled3)
- id — number — Primary key — NOT NULL
- category_id — number — Foreign key → categories.id — NOT NULL
- name — varchar2(255) — NOT NULL
- price — number — NOT NULL
- point — number — NOT NULL
- discount_rate — number — NOT NULL
- image1 — varchar2(255) — NOT NULL
- image2 — varchar2(255)
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
users
- id — number — Primary key — NOT NULL
- name — varchar2(255) — NOT NULL
- nickname — varchar2(255) — NOT NULL
- password — varchar2(255) — NOT NULL
- email — varchar2(255) — NOT NULL
- phone — varchar2(255)
- zip — varchar2(255)
- address1 — varchar2(255)
- address2 — varchar2(255)
- point — number — NOT NULL
- level — number — NOT NULL
- status — enum("waiting", "actived", "rejected", "banned", "leaved", "dormanted") — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- deleted_at — date
zzims (Untitled5)
- id — number — Primary key — NOT NULL
- user_id — number — Foreign key → users.id — NOT NULL
- productid — number — Foreign key → products.id — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL