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