commu

Tables (8)

admin (Untitled6)

  • id — BIGINT — Primary key — NOT NULL
  • adminid — VARCHAR
  • password — VARCHAR
  • name — VARCHAR
  • level — INT

comment (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • comment_content — TEXT
  • comment_photo — TEXT
  • comment_writer — VARCHAR
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

maincategory (Untitled7)

  • id — BIGINT — Primary key — NOT NULL
  • maincategoryname — VARCHAR
  • photocode — INT

notis (Untitled5)

  • id — BIGINT — Primary key — NOT NULL
  • noti_content — TEXT
  • 분류 (noti_code) — INT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL
  • comment_id — BIGINT — Foreign key → comment.id — NOT NULL

post (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • description — TEXT
  • 사진갯수 (code) — INT
  • comment_num — INT
  • hit — INT
  • notice — INT
  • mainimg — VARCHAR
  • writer
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • maincategory_id — BIGINT — Foreign key → maincategory.id — NOT NULL
  • subcategory_id (subcateogry_id) — BIGINT — Foreign key → subcategory.id — NOT NULL

reply (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • reply_content — TEXT
  • reply_photo — TEXT
  • reply_writer — VARCHAR
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • comment_id — BIGINT — Foreign key → comment.id — NOT NULL

subcategory (Untitled8)

  • id — BIGINT — Primary key — NOT NULL
  • subcategoryname — VARCHAR
  • photocode — INT
  • maincateogry_id — BIGINT — Foreign key → maincategory.id — NOT NULL

user (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • userid — VARCHAR
  • password — VARCHAR
  • email — VARCHAR
  • level — VARCHAR
  • social — INT
  • img — TEXT