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