sirgenie-test-db

Tables (6)

Folder (folder)

  • Folder ID (folder_id) — INT — Primary key — NOT NULL
  • MemberId (memberId) — VARCHAR(255) — Foreign key → Member.MemberId — NOT NULL
  • Point ID (point_id) — INT — Foreign key → Point.Point ID — NOT NULL
  • Created_At (created_at) — TIMESTAMP
  • Folder Name (folder_name) — VARCHAR(255)

Member (member)

  • MemberId (memberId) — VARCHAR(255) — Primary key — NOT NULL
  • Password (password) — VARCHAR(255)
  • Created_At (created_at) — TIMESTAMP
  • Updated_At (updated_at) — TIMESTAMP

Point (point)

  • Point ID (point_id) — INT — Primary key — NOT NULL
  • Point Num (point_num) — INT

Tag (tag)

  • Tag Name (tag_name) — VARCHAR(255) — Primary key — NOT NULL

UserImage (userImage)

  • Image ID (image_id) — INT — Primary key — NOT NULL
  • Folder ID (folder_id) — INT — Foreign key → Folder.Folder ID — NOT NULL
  • Path (path) — VARCHAR(255)
  • Upload Date (upload_date) — TIMESTAMP

UserImageTag (userImageTag)

  • UserImageTag ID (user_image_tag_id) — INT — Primary key — NOT NULL
  • Image ID (image_id) — INT — Foreign key → UserImage.Image ID — NOT NULL
  • Tag Name (tag_name) — VARCHAR(255) — Foreign key → Tag.Tag Name — NOT NULL