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