SNS
Tables (16)
Board (Untitled2)
- Key (board_idx) — bigint — Primary key — NOT NULL
- Field (contents) — varchar(255) — NOT NULL
- Field3 (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
- Key (member_idx) — bigint — Foreign key → Member.Key — NOT NULL
Board_Hashtag (Untitled12)
- Key (board_idx) — bigint — Foreign key → Board.Key — NOT NULL
- Key (hashtag_idx) — bigint — Foreign key → Hashtag.Key — NOT NULL
Boards_Like (Untitled4)
- like_idx — bigint — Primary key — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
- Key (board_idx) — bigint — Foreign key → Board.Key — NOT NULL
ChatRoom (Untitled6)
- Key (room_idx) — bigint — Primary key — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field (name) — varchar(25) — NOT NULL
ChatRoom_User (Untitled16)
- Key (chatroom_user_idx) — bigint — Primary key — NOT NULL
- Key (member_idx) — bigint — Foreign key → Member.Key — NOT NULL
- Key (room_idx) — bigint — Foreign key → ChatRoom.Key — NOT NULL
Comments (Untitled8)
- Key (comments_idx) — bigint — Primary key — NOT NULL
- Field (contents) — varchar(255) — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
- Key (board_idx) — bigint — Foreign key → Board.Key — NOT NULL
- Key (member_idx) — bigint — Foreign key → Member.Key — NOT NULL
Comments_Like (Untitled13)
- Key (comments_like_idx) — bigint — Primary key — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
- Key (comments_idx) — bigint — Foreign key → Comments.Key — NOT NULL
Follow (Untitled5)
- Field (created_at) — timestamp — NOT NULL
- Key (follower_idx) — bigint — Foreign key → Member.Key — NOT NULL
- Key (following_idx) — bigint — Foreign key → Member.Key — NOT NULL
Hashtag (Untitled11)
- Key (hashtag_idx) — bigint — Primary key — NOT NULL
- Field (tag) — varchar(255) — NOT NULL
Image (Untitled3)
- Key (image_idx) — bigint — Primary key — NOT NULL
- Field (image_url) — text — NOT NULL
- Field2 (created_at) — timestamp
- Field3 (updated_at) — timestamp
- Key (board_idx) — bigint — Foreign key → Board.Key — NOT NULL
Member (Untitled)
- Key (member_idx) — bigint — Primary key — NOT NULL
- Field2 (name) — varchar(25) — NOT NULL
- Field3 (id) — varchar(25) — NOT NULL
- Field (email) — varchar(50) — NOT NULL
- Field (password) — varchar(250) — NOT NULL
- Field3 (tel) — varchar(50) — NOT NULL
- Field4 (birth) — timestamp — NOT NULL
- Field2 (gender) — varchar(5) — NOT NULL
- Field (profile) — varchar(200)
- Field4 (img) — text
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
Messages (Untitled15)
- Key (message_idx) — bigint — Primary key — NOT NULL
- Field (message) — text — NOT NULL
- Field2 (send_time) — timestamp — NOT NULL
- Key (sender_idx) — bigint — Foreign key → Member.Key — NOT NULL
- Key (room_idx) — bigint — Foreign key → ChatRoom.Key — NOT NULL
Story (Untitled7)
- Key (story_idx) — bigint — Primary key — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field (updated_at) — timestamp — NOT NULL
- Key (member_idx) — bigint — Foreign key → Member.Key — NOT NULL
Story_Like (Untitled14)
- Key (story_like_idx) — bigint — Primary key — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
- Key (story_idx) — bigint — Foreign key → Story.Key — NOT NULL
Story_sub (Untitled9)
- Key (story_sub_idx) — bigint — Primary key — NOT NULL
- Field (contents) — varchar(100) — NOT NULL
- Field2 (location_x) — int — NOT NULL
- Field (location_y) — int — NOT NULL
- Field2 (tilt) — int — NOT NULL
- Field (type) — varchar(50) — NOT NULL
- Key (story_idx) — bigint — Foreign key → Story.Key — NOT NULL
Video (Untitled10)
- Key (video_idx) — bigint — Primary key — NOT NULL
- Field (video_url) — text — NOT NULL
- Field2 (created_at) — timestamp — NOT NULL
- Field3 (updated_at) — timestamp — NOT NULL
- Key (board_idx) — bigint — Foreign key → Board.Key — NOT NULL