communities

Tables (3)

communities

  • commu_no — int — Primary key — NOT NULL
  • commu_id — varchar(20) — Foreign key → user.user_id — NOT NULL
  • commu_title — varchar(200) — NOT NULL
  • commu_content — varchar(1000) — NOT NULL
  • commu_img — varchar(500)
  • commu_img2 — varchar(500)
  • commu_img3 — varchar(500)
  • category1 — varchar(200) — NOT NULL
  • commu_view — int
  • commu_date — timestamp

reply

  • reply_no — int — Primary key — NOT NULL
  • reply_id — varchar(20) — Foreign key → user.user_id
  • reply_content — varchar(300)
  • commu_no — int — Foreign key → communities.commu_no
  • reply_date — timestamp

user

  • user_id — varchar(20) — Primary key — NOT NULL
  • user_pw — varchar(20) — NOT NULL
  • user_email — varchar(100) — NOT NULL
  • user_tel — varchar(20) — NOT NULL
  • user_nickname — varchar(20) — NOT NULL
  • user_img — varchar(500)
  • user_level — varchar(20) — NOT NULL
  • user_interest — varchar(20)
  • user_state — tinyint(1) — NOT NULL
  • user_joindate — timestamp — NOT NULL
  • user_visit — int — NOT NULL
  • user_name — varchar(100) — NOT NULL
  • user_addr1 — varchar(100) — NOT NULL
  • user_addr2 — varchar(100) — NOT NULL
  • user_addr3 — varchar(100) — NOT NULL
  • user_addr4 — varchar(100) — NOT NULL
  • user_addr5 — varchar(100)
  • user_recentvisit — date
  • user_commu — int
  • user_reply — int