freeLog

Tables (5)

comment (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • user_id (user pk) — int(11) — Foreign key → user.id — NOT NULL
  • post_id (post pk) — int(11) — Foreign key → post.id — NOT NULL
  • resource_id (pk2) — int(11) — Foreign key → resource.id — NOT NULL
  • text (Field)
  • is_active (Field3)
  • created_at (Field4)
  • updated_at (Field5)

follow (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • follower_id (pk) — int(11) — Foreign key → user.id — NOT NULL
  • followee_id (pk2) — int(11) — Foreign key → user.id — NOT NULL
  • is_active (Field) — tinyint(1)
  • created_at (u)
  • updated_at (Field2)

post

  • id (pk) — int(11) — Primary key — NOT NULL
  • user_id (user_pk) — int(11) — Foreign key → user.id — NOT NULL
  • title (post title) — varchar
  • content (post content) — varchar
  • like (post like) — int(11)
  • is_active (Field) — tinyint(1)
  • created_at (Field2)
  • updated_at (Field3)

resource (Untitled)

  • id (pk) — int(11) — Primary key — NOT NULL
  • post_id (post pk) — int(11) — Foreign key → post.id — NOT NULL
  • position (Field4)
  • text (Field5)
  • link (s3 link) — varchar
  • is_active (Field) — tinyint(1)
  • created_at (Field2)
  • updated_at (Field3)

user

  • id (pk) — int(11) — Primary key — NOT NULL
  • uuid (UUID) — varchar(36)
  • username (@user alias) — varchar
  • email — varchar
  • password (pw) — password
  • photo (profile photo) — varchar
  • is_active (삭제여부) — tinyint(1)
  • created_at (생성날짜) — datetime
  • updated_at (수정날짜) — datetime