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