test

Tables (5)

comment

  • comment_num — int — Primary key — NOT NULL
  • question_num — int — Foreign key → question.question_num — NOT NULL
  • comment_content — varchar(1000) — NOT NULL
  • comment_date — TIMESTAMP — NOT NULL
  • comment_title — varchar(50)

customers

  • member_code — int — Primary key — NOT NULL
  • member_id — VARCHAR(15) — NOT NULL
  • member_pw — VARCHAR(15) — NOT NULL
  • member_name — VARCHAR(20) — NOT NULL
  • member_addr — VARCHAR(60) — NOT NULL
  • member_email — VARCHAR(12) — NOT NULL
  • member_birth — DATE — NOT NULL
  • member_gender — VARCHAR(5) — NOT NULL
  • member_phone — VARCHAR(15) — NOT NULL
  • member_level — VARCHAR(7) — NOT NULL
  • member_join — TIMESTAMP

products

  • product_code — int — Primary key — NOT NULL
  • img_view — VARCHAR(50) — NOT NULL
  • product_type — int — NOT NULL
  • product_type_name — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(50) — NOT NULL
  • product_price — INT — NOT NULL
  • product_read — INT — NOT NULL
  • product_content — VARCHAR(1000) — NOT NULL
  • product_count — INT — NOT NULL
  • product_date — TIMESTAMP
  • product_like — int — NOT NULL

question

  • question_num — int — Primary key — NOT NULL
  • member_code — int — Foreign key → customers.member_code — NOT NULL
  • question_title — varchar(20)
  • question_content — varchar(1000)
  • question_date — TIMESTAMP — NOT NULL

review

  • review_num — int — Primary key — NOT NULL
  • product_code — int — Foreign key → products.product_code — NOT NULL
  • member_code — int — Foreign key → customers.member_code — NOT NULL
  • review_star — INT — NOT NULL
  • review_title — varchar(20)
  • review_content — varchar(1000) — NOT NULL
  • review_date — TIMESTAMP — NOT NULL