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