ㅁㅁㅁ
Tables (6)
free_board
- id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- image — varchar(255)
- user_id — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
musician_board
- id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- image — varchar(255)
- user_id — varchar(50) — Foreign key → users.user_id
- created_at — timestamp — NOT NULL
notice
- id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- image — varchar(255)
- user_id — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
notice_favorite
- id — int(11) — Primary key — NOT NULL
- notice_id — int(11) — Foreign key → notice.id — NOT NULL
- user_id — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
user_interests
- user_id — varchar(50) — Foreign key → users.user_id
- interest — varchar(50)
users
- user_id — varchar(50) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- age — int(11) — NOT NULL
- password — varchar(255) — NOT NULL
- phone — varchar(15)
- gender — enum('male','female') — NOT NULL
- address — varchar(255)
- introduction — text
- profile_image — varchar(255)
- musician — enum('yes','no') — NOT NULL