Nuriwoolim

Tables (7)

board (Untitled)

  • id (Key) — Bigint — Primary key — NOT NULL
  • title (Field) — Varchar(20) — NOT NULL
  • description (Field2) — Varchar(100)
  • type (Field3) — Enum_String

comment (CopyOfCopyOfUntitled)

  • id (Key) — Bigint — Primary key — NOT NULL
  • content (Field2) — Text — NOT NULL
  • created_at (Field4) — DateTime — NOT NULL
  • updated_at (Field5) — DateTime
  • writer_id (Key4) — Bigint — Foreign key → user.id — NOT NULL
  • post_id (Key2) — Bigint — Foreign key → post.id — NOT NULL

post (CopyOfUntitled)

  • id (Key) — Bigint — Primary key — NOT NULL
  • title (Field) — Varchar(20) — NOT NULL
  • content (Field2) — Text — NOT NULL
  • type (Field3) — Enum_String
  • created_at (Field4) — DateTime — NOT NULL
  • updated_at (Field5) — DateTime
  • writer_id (Key4) — Bigint — Foreign key → user.id — NOT NULL
  • board_id (Key5) — Bigint — Foreign key → board.id — NOT NULL

schedule (Untitled2)

  • id (Key) — Bigint — Primary key — NOT NULL
  • title (Field) — Varchar(20)
  • description (Field2) — Varchar(100)
  • start (Field3) — Integer — NOT NULL
  • end (Field4) — Integer — NOT NULL
  • day_of_week (Field5) — Enum_Int — NOT NULL
  • week_id (Key3) — Bigint — Foreign key → week_schedule.id
  • user_id (Key4) — Bigint — Foreign key → user.id — NOT NULL

time_table (CopyOfUntitled2)

  • id (Key) — Bigint — Primary key — NOT NULL
  • title (Field) — Varchar(20)
  • description (Field2) — Varchar(100)
  • start (Field3) — Integer — NOT NULL
  • end (Field4) — Integer — NOT NULL
  • date (Field5) — Date — NOT NULL
  • user_id (Key4) — Bigint — Foreign key → user.id — NOT NULL

user (Member)

  • id (Key) — Bigint — Primary key — NOT NULL
  • username (Field) — Varchar(20) — NOT NULL
  • email (Field3) — Varchar(30) — NOT NULL
  • password (Field2) — Varchar(100) — NOT NULL
  • nickname (Field4) — VarChar(10) — NOT NULL
  • type (Field5) — Enum_Int — NOT NULL
  • create_date (Field6) — Date — NOT NULL
  • year (Field7) — Integer
  • email_authentificated (Field8) — boolean — NOT NULL

week_schedule (CopyOfUntitled22)

  • id (Key) — Bigint — Primary key — NOT NULL
  • title (Field) — Varchar(20)
  • description (Field2) — Varchar(100)
  • user_id (Key2) — Bigint — Foreign key → user.id — NOT NULL