ss
Tables (7)
bookmark
- bmNo — bigint
- uNo — bigint — NOT NULL
- fNo — bigint — NOT NULL
- bmDate — datetime — NOT NULL — 날짜
freeboard
- bNo — bigint
- uNo — bigint — NOT NULL
- bTitle — varchar(100) — NOT NULL
- bContext — text
- bDate — datetime — NOT NULL
freeboard_comment
- bcNo — bigint
- bNo — bigint — NOT NULL
- bcContent — text — NOT NULL
- uNo — bigint — NOT NULL
- bcDate — datetime — NOT NULL
futsal
- fNo — bigint
- fName — varchar(40) — NOT NULL
- fRegionA — varchar(10) — NOT NULL
- fRegionB — varchar(10) — NOT NULL
- fAddress — varchar(100) — NOT NULL — 지역 입력하면 앞에 자동 입력됨
- fTime — varchar(30)
- fTel — varchar(11)
- uNo — bigint — NOT NULL
- fImage — varchar(200) — (올릴 시 default 추가해야 함)
- fDetail — text
- fDate — datetime — NOT NULL
- fBookMark — int — NOT NULL
futsal_comment
- fcNo — bigint
- fNo — bigint — NOT NULL
- fcContent — text — NOT NULL
- uNo — bigint — NOT NULL
- fcDate — datetime — NOT NULL
notice
- nNo — bigint
- uNo — bigint — NOT NULL
- nTitle — varchar(100) — NOT NULL
- nContext — text
- nDate — datetime — NOT NULL
user
- uNo — bigint
- uId — varchar(20)
- uPw — varchar(60)
- uNickName — varchar(20)
- uMail — varchar(40) — NOT NULL
- uPhone — varchar(11)
- uRegionA — varchar(20)
- uRegionB — varchar(20)
- uRole — varchar(1)