123
Tables (18)
admin
- idx — bigint — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(20)
- name — varchar(30) — NOT NULL
- nickname — varchar(10) — NOT NULL
- status — tinyint — NOT NULL
- last_connection — datetime — NOT NULL
- phone_number — varchar(20)
board_like
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — NOT NULL
- board_idx — bigint — NOT NULL
bookmark
- idx — bigint — Primary key — NOT NULL
- board_idx — bigint — NOT NULL
- user_idx — bigint — NOT NULL
calendar
- idx — int — Primary key — NOT NULL
- plan_idx — bigint — NOT NULL
category
- idx — varchar(20) — Primary key — NOT NULL
- title — varchar(30) — NOT NULL
chatting_room
- idx — bigint — Primary key — NOT NULL
- response_idx — bigint — NOT NULL
- request_idx — bigint — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- status — tinyint — NOT NULL
comment
- idx — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- board_idx — bigint — NOT NULL
- user_idx — bigint — NOT NULL
comment_like
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — NOT NULL
- comment_idx — bigint — NOT NULL
community_board
- idx — bigint — Primary key — NOT NULL
- title — varchar(30) — NOT NULL
- content — text — NOT NULL
- image — varchar(200)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- user_idx — bigint — NOT NULL
- category — varchar(20) — NOT NULL
joongna_board
- idx — bigint — Primary key — NOT NULL
- title — varchar(30) — NOT NULL
- content — text — NOT NULL
- image — varchar(200) — NOT NULL
- created_at — datetime — NOT NULL
- update_at — datetime — NOT NULL
- status — tinyint — NOT NULL
- price — int — NOT NULL
- user_idx — bigint — NOT NULL
messages
- idx — bigint — Primary key — NOT NULL
- sendtime — datetime — NOT NULL
- content — text — NOT NULL
- chatting_room_idx — bigint — NOT NULL
- sender_idx — bigint — NOT NULL
plan
- idx — bigint — Primary key — NOT NULL
- title — varchar(30) — NOT NULL
- contents — text — NOT NULL
- start_date — date — NOT NULL
- course_num — int — NOT NULL
- end_date — date — NOT NULL
project
- idx — bigint — Primary key — NOT NULL
- title — varchar(30) — NOT NULL
- video — varchar(200)
- contents — text — NOT NULL
- course_num — int — NOT NULL
- team_name — varchar(30) — NOT NULL
- member — varchar(100) — NOT NULL
recomment
- idx — bigint — Primary key — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- comment_idx — bigint — NOT NULL
- user_idx — bigint — NOT NULL
recomment_like
- idx — bigint — Primary key — NOT NULL
- recomment_idx — bigint — NOT NULL
- user_idx — bigint — NOT NULL
reservation
- idx — bigint — Primary key — NOT NULL
- num_of_mem — int — NOT NULL
- reserve_date — datetime — NOT NULL
- table_num — int — NOT NULL
- created_at — datetime — NOT NULL
- reserve_mem_id — bigint — NOT NULL
- status — tinyint — NOT NULL
seat
- idx — bigint — Primary key — NOT NULL
- seat_num — int — NOT NULL
- floor — int — NOT NULL
- reservation_idx — bigint — NOT NULL
- status — tinyint — NOT NULL
user
- idx — bigint — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(20)
- name — varchar(30) — NOT NULL
- nickname — varchar(10) — NOT NULL
- role — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- phone_number — varchar(20) — NOT NULL
- address — varchar(100)
- socialLogined — tinyint — NOT NULL
- access_token — varchar(255)
- refresh_token — varchar(255)
- course_num — int — NOT NULL
- status — tinyint — NOT NULL