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