planz
Tables (15)
board
- boardnum — bigint
- boardtitle — varchar(100)
- boardcontents — varchar(1000)
- travelPlansStart — datetime
- travelPlansEnd — datetime
- updatedate — datetime
- created — datetime
- price — bigint
- userid — varchar(300)
category
- categoryname — varchar(500)
chatmessage
- chatno — bigint
- type — varchar(20) — NOT NULL
- roomno — int — NOT NULL
- userid — varchar(300) — NOT NULL
- message — varchar(2000) — NOT NULL
- time — timestamp
chatroom
- roomno — bigint
- roomname — varchar(300) — NOT NULL
- bannuser — varchar(300)
- adminid — varchar(300)
- roomtype — varchar(300)
chatuser
- roomno — bigint
- roomname — varchar(300) — NOT NULL
- userid — varchar(300)
- last_read_chatno — int
deal
- boardnum — bigint
- userid — varchar(300)
- # — 구매자
- #구매자 — 사용여부
- 자동으로 — 승인
file
- systemname — varchar(2000)
- orgname — varchar(2000)
- fileid — varchar(300)
place
- placeid — bigint
- placename — varchar(300) — NOT NULL
- addr — varchar(1000) — NOT NULL
- phone — varchar(20)
- category — varchar(500) — NOT NULL
place_reply
- placeid — bigint
- replynum — bigint
plan
- plannum — bigint
- plantitle — varchar(1000) — NOT NULL
- planmemo — text
- startdate — varchar(10) — NOT NULL
- #ex) — 2024_05_09 — NOT NULL
- category — varchar(1000) — NOT NULL
plan_place
- plannum — bigint
- placeid — bigint
reply
- replynum — bigint
- replycontents — varchar(2000)
- regdate — datetime
- updatedate — datetime
- userid — varchar(300)
schedule
- schedulenum — bigint
- scheduletitle — varchar(100) — NOT NULL
- schedulememo — text
- starttime — varchar(16) — NOT NULL
- #ex) — 2024_05_09_hh:mm — NOT NULL
- plannum — bigint
user
- userid — varchar(300)
- userpw — varchar(300) — NOT NULL
- username — varchar(300) — NOT NULL
- userphone — varchar(13)
- useremail — varchar(300)
- usergender — char(3) — NOT NULL
- zipcode — varchar(300) — NOT NULL
- addr — varchar(1000)
- addrdetail — varchar(1000) — NOT NULL
- addretc — varchar(300)
- userprofile — varchar(300)
- #유저사진 — usercoin
- category — varchar(1000) — NOT NULL
user_plan
- userid — varchar(300)
- plannum — bigint
- part — varchar(300)