NOONEE
Tables (8)
category_mst
- category_code — INT — Primary key — NOT NULL
- product_code — INT — Foreign key → product_mst.product_code — NOT NULL
- category_name — VARCHAR
collection_mst
- collection_code — INT — Primary key — NOT NULL
- product_code — INT — Foreign key → product_mst.product_code — NOT NULL
- collection_name — VARCHAR
faq_mst
- faq_code — INT — Primary key — NOT NULL
- faq_title — VARCHAR
- faq_content — VARCHAR
inquiry_mst
- inquiry_code — INT — Primary key — NOT NULL
- user_code (user_code2) — INT — Foreign key → user_mst.user_code — NOT NULL
- user_code — INT
- inquiry_title — VARCHAR
- user_name — VARCHAR
- inquiry_password — VARCHAR
- inquiry_content — VARCHAR
- inquiry_count — INT
- create_datec (create_date) — DATETIME
- update_date — DATETIME
option_mst
- option_code (Key) — INT — Primary key — NOT NULL
- option_name (Field) — VARCHAR
product_mst
- product_code — INT — Primary key — NOT NULL
- category_code — INT
- collection_code — INT
- product_name — VARCHAR
- product_price — VARCHAR
- product_img — VARCHAR
- create_date — DATETIME
- update_date — DATETIME
user_dtl
- user_code — INT — Primary key — NOT NULL
- user_code (user_code2) — INT — Foreign key → user_mst.user_code — NOT NULL
- user_profile_img — VARCHAR
- create_date — DATETIME
- update_date — DATETIME
user_mst
- user_code — INT — Primary key — NOT NULL
- user_name — VARCHAR
- user_email — VARCHAR
- user_password — VARCHAR
- oauth2_id — VARCHAR
- user_phone — VARCHAR
- user_roles — VARCHAR
- user_provider — VARCHAR
- create_date — DATETIME
- update_date — DATETIME