gwabang2

Tables (9)

article

  • id — bigint(20) — Primary key — NOT NULL
  • content — tinytext
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • title — varchar(255)
  • updated_at — datetime(6)
  • category_id — bigint(20)
  • member_id — bigint(20)
  • group_code — varchar(255)

articlelike

  • id — bigint(20) — Primary key — NOT NULL
  • article_count — bigint(20)
  • article_id — bigint(20)
  • member_id — bigint(20)

category

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • group_code — int(11) — NOT NULL

comment

  • id — bigint(20) — Primary key — NOT NULL
  • content — tinytext
  • create_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • article_id — bigint(20)
  • member_id — bigint(20)

commentlike

  • id — bigint(20) — Primary key — NOT NULL
  • comment_count — bigint(20)
  • comment_id — bigint(20)
  • member_id — bigint(20)

department

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • group_code — int(11)

departmentgroup

  • code — int(11) — Primary key — NOT NULL
  • name — varchar(255)

member

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • updated_at — datetime(6)
  • department_id — bigint(20) — NOT NULL
  • nickname — varchar(100)

refresh_token

  • id — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — NOT NULL
  • refresh_token — varchar(1000) — NOT NULL