SoonNyang
Tables (11)
authority
- authority_name — VARCHAR(50) — Primary key — NOT NULL
cat
- cat_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- age — VARCHAR(255)
- gender — VARCHAR(255)
- follower_cnt — BIGINT
- image_url — VARCHAR(255)
- is_active — VARCHAR(255) — NOT NULL
- tnrdate — date
disease (CopyOfdisease_timeline)
- disease_id — Primary key — NOT NULL
- name — VARCHAR(50)
- explanation — VARCHAR(500)
disease_timeline
- disease_timeline_id — Primary key — NOT NULL
- disease_id — Foreign key → disease.disease_id — NOT NULL
- cat_id — BIGINT — Foreign key → cat.cat_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- image_url — VARCHAR(500)
- created_at (Field3) — datetime
feedspot (Untitled3)
- feedspot_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- description — VARCHAR(50)
- image_url — VARCHAR(255)
- latitude — DOUBLE
- longitude — DOUBLE
follow (Untitled2)
- follow_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- cat_id — BIGINT — Foreign key → cat.cat_id — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime
- deleted_at — datetime
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255)
- introduction — VARCHAR(100)
member_authority
- authority_name — VARCHAR(50) — Foreign key → authority.authority_name — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
post
- post_id — BIGINT — Primary key — NOT NULL
- cat_id — BIGINT — Foreign key → cat.cat_id
- member_id — BIGINT — Foreign key → member.member_id
- latitude — DOUBLE
- longitude — DOUBLE
- content — VARCHAR(255)
- image — VARCHAR(255)
- like_count — BIGINT
- created_at — datetime — NOT NULL
- modified_at — datetime
- deleted_at — datetime
postLike (Untitled)
- post_like_id (Key) — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
post_image
- post_image_id — BIGINT — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- modified_at — datetime
- deleted_at — datetime
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- original_file_name — VARCHAR(255)
- image_url — VARCHAR(500) — NOT NULL