gummy-dang
Tables (10)
Comment (comment)
- id (comment_id) — Primary key — NOT NULL
- content
- createdAt (created_at)
- updatedAt (updated_at)
- memberId (member_id) — bigint — Foreign key → Member.id — NOT NULL
- postId (post_id) — bigint — Foreign key → Post.id — NOT NULL
- comment_depth — Foreign key → Comment.id — NOT NULL
Gummy (gummy)
- gummyId (gummy_id) — bigint — Primary key — NOT NULL
- imageUrl — varchar(255) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
Like (like)
- id (like_id) — bigint — Primary key — NOT NULL
- memberId (member_id) — bigint — Foreign key → Member.id — NOT NULL
- postId (post_id) — bigint — Foreign key → Post.id — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
Member (member)
- id (member_id) — bigint — Primary key — NOT NULL
- userName (user_name) — varchar(20) — NOT NULL
- password — varchar(255) — NOT NULL
- address — varchar(255)
- phoneNumber (phone_number) — varchar(14)
- socialId (social_id) — varchar(20)
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
Post (post)
- id (post_id) — bigint — Primary key — NOT NULL
- memberId (member_id) — bigint — Foreign key → Member.id — NOT NULL
- title — varchar(50) — NOT NULL
- likeCount (like_count) — bigint
- description — varchar(255)
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
PostCoordinate (post_coordinate)
- id (post_coordinate_id) — bigint — Primary key — NOT NULL
- postId (post_id) — bigint — Foreign key → Post.id — NOT NULL
- coordinate — varchar(50) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — NOT NULL
PostImage (post_image)
- id (post_image_id) — bigint — Primary key — NOT NULL
- postId (post_id) — bigint — Foreign key → Post.id — NOT NULL
- imageUrl (image_url) — varchar(255) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
RecordImage (record_image)
- id (record_image_id) — bigint — Primary key — NOT NULL
- walkRecordId (walk_record_id) — bigint — Foreign key → WalkRecord.id — NOT NULL
- imageUrl (image_url) — varchar(255) — NOT NULL
Reward (reward)
- id (reward_id) — bigint — Primary key — NOT NULL
- memberId (member_id) — bigint — Foreign key → Member.id — NOT NULL
- giveStatus (give_status) — enum — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
WalkRecord (walk_record)
- id (walk_record_id) — bigint — Primary key — NOT NULL
- memberId (member_id) — bigint — Foreign key → Member.id — NOT NULL
- gummyId (gummy_id) — bigint — Foreign key → Gummy.gummyId — NOT NULL
- id (reward_id) — bigint — Foreign key → Reward.id — NOT NULL
- departure — varchar(50) — NOT NULL
- arrival — varchar(50) — NOT NULL
- recordDate (record_date) — date — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL