SKKU-DM

Tables (11)

Comment

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • post_id — INTEGER — NOT NULL
  • parent_id — INTEGER
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Major

  • id — SERIAL
  • name — VARCHAR(255) — NOT NULL
  • meta — JSONB — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Post

  • id — SERIAL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • userId — INTEGER — NOT NULL
  • likes — INTEGER
  • tags — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Profile

  • id — SERIAL
  • image_url — VARCHAR(255) — NOT NULL
  • intro — TEXT — NOT NULL
  • interests — VARCHAR — NOT NULL
  • public — BOOLEAN — NOT NULL
  • user_id — INTEGER — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Square

  • id — SERIAL
  • name — VARCHAR(255) — NOT NULL
  • leader_id — INTEGER — NOT NULL
  • major_id — INTEGER
  • max — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

SquarePostComment

  • id — SERIAL
  • userId — INTEGER — NOT NULL
  • squarePostId — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • id — SERIAL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — Role
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • admit_year — INTEGER
  • real — BOOLEAN

mock_apply

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • major_id — INTEGER — NOT NULL
  • score — FLOAT — NOT NULL

square_post

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • square_id — INTEGER — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_major

  • user_id — INTEGER — Primary key — NOT NULL
  • major_id — INTEGER — Primary key — NOT NULL
  • origin — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_square

  • user_id — INTEGER — Primary key — NOT NULL
  • square_id — INTEGER — Primary key — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP