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