1
Tables (11)
garbage
- garbage_id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- classification — VARCHAR(100) — NOT NULL
- note — TEXT
interest
- interest_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(12) — NOT NULL
- product_id — INT — NOT NULL
- interest_date — DATETIME — NOT NULL
notification
- notification_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(12) — NOT NULL
- message — TEXT — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
price_history
- history_id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- price — DECIMAL(20,2) — NOT NULL
- date_recorded — DATETIME — NOT NULL
product
- product_id — INT — Primary key — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- description — TEXT
- product_url — TEXT
- category — VARCHAR(100) — NOT NULL
- sub_category — VARCHAR(100) — NOT NULL
- brand — VARCHAR(100)
- discount — INT
product_price
- price_id — INT — Primary key — NOT NULL
- shop_name — VARCHAR(100) — NOT NULL
- shop_url — VARCHAR(255) — NOT NULL
- price — DECIMAL(20,2) — NOT NULL
- hit — DOUBLE
- last_updated — DATETIME
- product_id — INT — NOT NULL
recipe
- RCP_SNO — BIGINT — Primary key — NOT NULL
- RCP_TTL — VARCHAR(200)
- CKG_NM — VARCHAR(40) — NOT NULL
- recipe_hit — INT — NOT NULL
- recipe_category — VARCHAR(100) — NOT NULL
- recipe_ingredients — TEXT — NOT NULL
- user_id — VARCHAR(12) — NOT NULL
refrigerator
- refrigerator_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(12) — NOT NULL
- RCP_SNO — BIGINT — NOT NULL
- buy_date — DATETIME — NOT NULL
- use_date — DATETIME — NOT NULL
- frozen — TINYINT(1) — NOT NULL
- product_id — INT — NOT NULL
review
- review_id — INT — Primary key — NOT NULL
- review_name — TEXT — NOT NULL
- review — TEXT — NOT NULL
- rating — DECIMAL(2,1) — NOT NULL
- user_id — VARCHAR(12) — NOT NULL
- product_id — INT
- created_at — DATETIME — NOT NULL
tips
- tip_id — INT — Primary key — NOT NULL
- tip_title — TEXT
- tips — TEXT — NOT NULL
user
- user_id — VARCHAR(12) — Primary key — NOT NULL
- user_pw — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(10) — NOT NULL
- nickname — VARCHAR(16) — NOT NULL
- phone_num — VARCHAR(15) — NOT NULL
- email — VARCHAR(255) — NOT NULL