TEST1

Tables (10)

Loudspeaker

  • speaker_id — int — Primary key — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • title — varcar(20) — NOT NULL

b_qna

  • id — NUMBER — Primary key — NOT NULL
  • Field — VARCHAR2 — NOT NULL
  • id2 — NUMBER — Foreign key → users.users_id — NOT NULL
  • b_category — VARCHAR2(50)
  • b)title — VARCHAR2(50)
  • b_writer — VARCHAR2(15) — NOT NULL
  • b_content — VARCHAR2(1000)
  • b_date — TIMESTAMP — NOT NULL
  • b_hit — NUMBER — NOT NULL
  • pID — VARCHAR2(30) — NOT NULL
  • b_pwd — NUMBER
  • created_at — TIMESTAMP — Foreign key → users.created_at — NOT NULL

c_qna

  • c_no — NUMBER — Primary key — NOT NULL
  • id — NUMBER — Foreign key → b_qna.id — NOT NULL
  • created_at — TIMESTAMP — Foreign key → b_qna.created_at — NOT NULL
  • c_writer — VARCHAR2(15)
  • c_comment_date — TIMESTAMP — NOT NULL
  • c_content — VARCHAR2(2000) — NOT NULL

category

  • category_id — INT — Primary key — NOT NULL
  • category_id2 — INT — Foreign key → category.category_id
  • cate_name — VARCHAR2 — NOT NULL

order_status

  • order_status_id — NUMBER — Primary key — NOT NULL
  • order_status — VARCHAR2 — NOT NULL

orders

  • orders_id — NUMBER — Primary key — NOT NULL
  • products_id — NUMBER — Foreign key → products.products_id — NOT NULL
  • users_id — NUMBER — Foreign key → users.users_id — NOT NULL
  • order_status_id — NUMBER — Foreign key → order_status.order_status_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • created_at2 — TIMESTAMP — Foreign key → users.created_at — NOT NULL

product_images

  • id — INT — Primary key — NOT NULL
  • product_id — INT — Foreign key → products.products_id — NOT NULL
  • image_url — VARCHAR2(1000) — NOT NULL
  • created_at2 — TIMESTAMP — Foreign key → products.created_at2 — NOT NULL

products

  • products_id — NUMBER — Primary key — NOT NULL
  • users_id — NUMBER — Foreign key → users.users_id — NOT NULL
  • name — VARCHAR2
  • release_price — NUMBER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • hit — NUMBER — NOT NULL
  • price_i — NUMBER — NOT NULL
  • price_a — NUMBER — NOT NULL
  • review_title — VARCHAR2(10)
  • review_content — VARCHAR2(100)
  • review_star — NUMBER
  • category_id — NUMBER — Foreign key → category.category_id — NOT NULL
  • created_at2 — TIMESTAMP — Foreign key → users.created_at — NOT NULL

users

  • users_id — INT — Primary key — NOT NULL
  • created_at — TIMESTAMP — Primary key — NOT NULL
  • social_login_id — VARCHAR2
  • email — VARCHAR2
  • password — VARCHAR2
  • name — VARCHAR2
  • phone_number — VARCHAR2
  • point — INT
  • address — VARCHAR(200) — NOT NULL
  • updated_at — TIMESTAMP
  • Field — INT
  • user_login_id — VARCHAR2
  • products_id — INT — Foreign key → products.products_id — NOT NULL

wishlists

  • wishlists_id — INT — Primary key — NOT NULL
  • product_id — INT — Foreign key → products.products_id — NOT NULL
  • created_at2 — TIMESTAMP — Foreign key → products.created_at2 — NOT NULL