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