프로젝트1
테이블 (9)
Article
- num — bigint — 기본 키 — NOT NULL
- user_num — bigint — 외래 키 → users.num — NOT NULL
- tripPackage_num — bigint — 외래 키 → TripPackage.num
- title — varchar(100)
- place — varchar(20)
- content — MEDIUMTEXT
- thumbnail — varchar(500)
- temp — boolean
- created_at — timestamp
- date_start — timestamp
- date_end — timestamp
- like_count — int
- views — int
- user_nickname — varchar(15) — NOT NULL
BlogInfo
- num — bigint — 기본 키 — NOT NULL
- user_num — bigint — 외래 키 → users.num — NOT NULL
- title — varchar(100)
- title_img — varchar(500)
- visit_count — int
Comment
- num — bigint — 기본 키 — NOT NULL
- user_num — bigint — 외래 키 → users.num — NOT NULL
- article_num — bigint — 외래 키 → Article.num — NOT NULL
- content — varchar(1000)
- user_nickname — varchar(15) — NOT NULL
- user_email — varchar(40) — NOT NULL
- user_img — varchar(500)
- created_at — timestamp
- reply_num — bigint
- paragraph — text
Pre_Article
- num — bigint — 기본 키 — NOT NULL
- user_num — bigint — 외래 키 → users.num — NOT NULL
- date — timestamp
- comment — varchar(1000)
- place — varchar(20)
- media — varchar(500) — NOT NULL
TripPackage
- num — bigint — 기본 키 — NOT NULL
- user_num — bigint — 외래 키 → users.num — NOT NULL
- name — varchar(15)
TripPackageScooped
- user_num — bigint — 외래 키 → users.num — NOT NULL
- tripPackage_num — bigint — 외래 키 → TripPackage.num — NOT NULL
like_Article
- user_num — bigint — 외래 키 → users.num — NOT NULL
- article_num — bigint — 외래 키 → Article.num — NOT NULL
neighbor
- num — bigint — 기본 키 — NOT NULL
- user_num — bigint — 외래 키 → users.num — NOT NULL
- neighbor_num — bigint
- neighbor_nickname — varchar(15)
users
- num — bigint — 기본 키 — NOT NULL
- email — varchar(40)
- name — varchar(40)
- nickname — varchar(15)
- password — varchar(100)
- intro — varchar(1000) — NOT NULL
- imageSrc — varchar(500) — NOT NULL
- mainPost — int — NOT NULL
- valid — boolean — NOT NULL
- created_at — timestamp — NOT NULL