thymeleaf-board-app
Tables (9)
Copy Of Untitled (comments)
- Key (comment_id) — bigint(20) — Primary key — NOT NULL
- Key (board_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(80) — NOT NULL
- Field (content) — text — NOT NULL
- Field (create_date) — timestamp — NOT NULL
- Field (status) — char(1) — NOT NULL
Untitled (member)
- Key (member_id) — bigint(20) — Primary key — NOT NULL
- Key (sc_id) — bigint(20) — Foreign key → Untitled.Key
- Field (id) — varchar(80) — NOT NULL
- Field (password) — varchar(80) — NOT NULL
- Field (nickname) — varchar(100) — NOT NULL
- Field (email) — varchar(100) — NOT NULL
- Field (profile_picture) — varchar(255)
- Field (create_date) — timestamp — NOT NULL
- Field (status) — char(1) — NOT NULL
- Field (login_status) — char(1) — NOT NULL — N : 로그인하지 않은 상태 Y : 로그인한 상태
Untitled (board)
- Key (board_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(80) — NOT NULL
- Field (content) — text — NOT NULL
- Field (create_date) — timestamp — NOT NULL
- Field (status) — char(1) — NOT NULL
Untitled (social_type)
- Key (sc_id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(80) — NOT NULL
Untitled (token)
- Key (tocken_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (access_token) — varchar(255) — NOT NULL
- Field (refresh_token) — varchar(255)
Untitled (chatroom)
- Key (cr_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field (status) — char(1) — NOT NULL
Untitled (chatroom_join)
- Key (crj_id) — bigint(20) — Primary key — NOT NULL
- Key (cr_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (chat_message)
- Key (cm_id) — bigint(20) — Primary key — NOT NULL
- Key (cr_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text — NOT NULL
- Field (create_date) — timestamp — NOT NULL
Untitled (board_img)
- Key (bi_id) — bigint(20) — Primary key — NOT NULL
- Key (board_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (origin_name) — varchar(255) — NOT NULL
- Field (change_name) — varchar(255) — NOT NULL