project
Tables (4)
artboard
- pop_code — varchar(30) — Primary key — NOT NULL
- pop_name — varchar(200) — NOT NULL
- start_day — date
- end_day — date
- content — text
- rink — text
- weblink — blob
- place — varchar(255)
likelist
- like_code — int — Primary key — NOT NULL
- user_id — varchar(200)
- pop_code — varchar(30)
member
- user_id — varchar(30) — Primary key — NOT NULL
- pass — varchar(30) — NOT NULL
- email — varchar(255) — NOT NULL
- uname — varchar(100) — NOT NULL
- create_day — datetime
- update_day — datetime
- phone_num — varchar(20)
- birth — date
- gender — varchar(10)
- uevent — varchar(10)
popboard
- num — int — Primary key — NOT NULL
- user_id — varchar(200)
- pop_code — varchar(30)
- title — varchar(200)
- content — text
- star — int
- regtime — timestamp