side
Tables (11)
category
- category_id — bigint — NOT NULL
- name — varchar(255)
comment
- comment_id — bigint — NOT NULL
- user_id — bigint
- post_id — bigint
- create_date — datetime(6)
- contents — text
- parent_num — bigint
- c_group — int
- ref_order — int
- level — int
- deleted — tinyint
feed
- post_id — bigint — Foreign key → post.post_id — NOT NULL
image_file
- file_id — bigint — NOT NULL
- post_id — bigint
- image_path — varchar(1000)
likes
- like_id — bigint — NOT NULL
- user_id — bigint
- post_id — bigint
post
- post_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- contents — text — NOT NULL
- region_code — int — NOT NULL
- region_name — varchar(255) — NOT NULL
- dong_code — int — NOT NULL
- create_date — datetime — NOT NULL
- likes — int — NOT NULL
- post_type — varchar(30)
social
- post_id — bigint — Foreign key → post.post_id — NOT NULL
- title — varchar(20)
- hits — int
- start_date — datetime(6)
- end_date — datetime(6)
- current_nums — tinyint
- limited_nums — tinyint
- status — varchar(255)
- contact — varchar(255)
- category_id — bigint
social_tag
- social_tag_id — bigint — NOT NULL
- social_id — bigint
- tag_id — bigint
socialing
- socialing_id — bigint — NOT NULL
- social_id — bigint
- user_id — bigint
tag
- tag_id — bigint — NOT NULL
- category_id — bigint
- name — varchar(255)
users
- user_id — bigint — Primary key — NOT NULL
- user_type — varchar(255)
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- phone_number — varchar(255) — NOT NULL
- dong_code — int — NOT NULL
- dong_name — varchar(255)
- profile — varchar(255)
- refresh_token — varchar(1000)
- bio — varchar(255)
- user_status — varchar(255)
- sns_id — bigint