sample
Tables (11)
Achievement
- achiev_id — INT
- achiev_name — VARCHAR(100) — NOT NULL
- user_id — INT
- achiev_check — BOOLEAN
- title — VARCHAR(50) — NOT NULL
- title_img — VARCHAR(255)
Comment
- comment_no — INT
- post_id — INT
- comment — TEXT — NOT NULL — EXT NOT NUL
- user_id — INT
- comment_create_date — DATE
Festival
- fes_id — INT
- fes_name — VARCHAR(50) — NOT NULL
- fes_date — DATE — NOT NULL
- fes_enddate — DATE — NOT NULL
Follow
- follow_id — INT
- follower_id — INT
- followed_id — INT
- follow_date — DATE
Like
- like_id — INT
- post_id — INT
- user_id — INT
Local
- local_id — INT
- local_name — VARCHAR(100) — NOT NULL
- local_img — VARCHAR(100)
Mileage
- mileage_id — INT
- user_id — INT
- mileage — INT
- change_history — TEXT — NOT NULL
- change_date — DATE
Post
- post_id — INT
- user_id — INT
- local_id — INT
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- img — VARCHAR(255)
- rating — FLOAT
- created_date — DATE
- updated_date — DATE
Schedule
- schedule_id — INT
- user_id — INT
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- start_date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- end_date — DATE — NOT NULL
- end_time — TIME — NOT NULL
- color — VARCHAR(50)
Store
- product_id — INT
- product_name — VARCHAR(50) — NOT NULL
- product_price — INT — NOT NULL
User
- user_id — INT
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- user_nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- birthday — DATE
- phone_num — VARCHAR(50) — NOT NULL
- local_img — VARCHAR(255)