asdf
Tables (4)
t_board
- boardnum — bigint — Primary key — NOT NULL
- boardtitle — varchar(300) — NOT NULL
- boardcontents — text — NOT NULL
- regdate — datetime
- updatedate — datetime
- readcount — int
- userid — varchar(300)
t_file
- systemname — varchar(2000)
- orgname — varchar(2000)
- boardnum — bigint
t_reply
- replynum — bigint — Primary key — NOT NULL
- boardnum — bigint — Foreign key → t_board.boardnum — NOT NULL
- userid — varchar(300)
- replycontents — varchar(2000)
- regdate — datetime
- updatedate — datetime
t_user
- useridx — int
- userid — varchar(300) — NOT NULL
- userpw — varchar(300) — NOT NULL
- username — varchar(300) — NOT NULL
- usergender — varchar(300)
- zipcode — varchar(300) — NOT NULL
- addr — varchar(1000)
- addrdetail — varchar(1000) — NOT NULL
- addretc — varchar(300)
- userhobby — varchar(2000)