mojire
Tables (13)
Untitled (inquiry)
- id — bigint(20) — Primary key — NOT NULL
- createdAt — datetime(6)
- updatedAt (updated_at) — datetime(6)
- title — varchar(255)
- content — varchar(255)
- status — varchar(255)
- id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
Untitled (bookmark)
- id — bigint(20) — Primary key — NOT NULL
- id (user_id) — bigint(20) — Foreign key → user.id
- id (board_id) — bigint(20) — Foreign key → Untitled.id
Untitled (board)
- id (board_id) — bigint(20) — Primary key — NOT NULL
- title — varchar(45) — NOT NULL
- thumbnail — bigtext
- content — mediumtext — NOT NULL
- id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- id (category_id) — bigint(20) — Foreign key → category.id — NOT NULL
- hotBoard (hot_board) — bit(1)
- likeCount (like_count) — bigint(20) — NOT NULL
Untitled (boardImage)
- id (board_image_id) — bigint(20) — Primary key — NOT NULL
- id (board_id) — bigint(20) — Foreign key → Untitled.id — NOT NULL
- imageUrl (image_url) — bigtext — NOT NULL
Untitled (boardLike)
- id — bigint(20) — Primary key — NOT NULL
- isLike (is_like) — bit(1)
- id (user_id) — bigint(20) — Foreign key → user.id
- id (board_id) — bigint(20) — Foreign key → Untitled.id
Untitled (boardViews)
- boardViewsId (board_views_id) — bigint(20) — Primary key — NOT NULL
- clientIpAddress (client_ip_address) — varchar(255)
- id (board_id) — bigint(20) — Foreign key → Untitled.id — NOT NULL
- viewAt (view_at) — datetime(6) — NOT NULL
bungae
- id (bungae_id) — bigint(20) — Primary key — NOT NULL
- createdAt (created_at) — datetime(6)
- updatedAt (updated_at) — datetime(6)
- title — varchar(30)
- content — bigtext
- place — bigtext
- recuritingMembers (recuriting_members) — int
- deadline (dealine) — datetime(6)
- status — varchar(255)
- id (category_id) — bigint(20) — Foreign key → category.id
- id (user_id) — bigint(20) — Foreign key → user.id
category
- id (category_id) — bigint(20) — Primary key — NOT NULL
- createdAt (created_at) — datetime(6)
- updatedAt (updated_at) — datetime(6)
- name — varchar(45) — NOT NULL
- imageUrl (image_url) — longtext — NOT NULL
- detail — longtext — NOT NULL
member
- id (member_id) — bigint(20) — Primary key — NOT NULL
- createAt (creaet_at) — datetime(6)
- updatedAt (updated_at) — datetime(6)
- id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- id (bungae_id) — bigint(20) — Foreign key → bungae.id — NOT NULL
report
- id (report_id) — Primary key — NOT NULL
- createdAt (created_at) — datetime(6)
- updatedAt (updated_at) — datetime(6)
- contents — bigtext
- id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- id (target_user_id) — bigint(20) — Foreign key → user.id — NOT NULL
user
- id (user_id) — bigint(20) — Primary key — NOT NULL
- email — varchar(45) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(45)
- number — bigint(20) — unique
- grade — bigint(20)
- department — varchar(45)
- image (image_url) — longtext
- bio — longtext
- instagram — varchar(45)
- anonymity — bit(1)
user_category (likes)
- id (likes_id) — bigint(20) — Primary key — NOT NULL
- id (user_id) — bigint(20) — Foreign key → user.id
- id (category_id) — bigint(20) — Foreign key → category.id
user_roles
- id (user_user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- roles — varchar(255)