nl-homepage

Tables (8)

CourseMember (Untitled4)

  • id (Key) — string — Primary key — NOT NULL
  • course-id (Key3) — string — Foreign key → Courses.id — NOT NULL
  • user-id (Key2) — string — Foreign key → Users.id — NOT NULL

Courses (Untitled3)

  • id (Key) — string — Primary key — NOT NULL
  • manager-id (Key2) — string — Foreign key → Users.id — NOT NULL
  • name (Field) — string — NOT NULL
  • description (Field2) — string — NOT NULL
  • kind (Field3) — string — NOT NULL
  • image-uri (Field4) — string

EventParticipants (Untitled8)

  • id (Key) — string — Primary key — NOT NULL
  • user-id (Key2) — string — Foreign key → Users.id — NOT NULL
  • event-id (Key3) — string — Foreign key → Events.id — NOT NULL

Events (Untitled5)

  • id (Key) — string — Primary key — NOT NULL
  • host-id (Key2) — string — Foreign key → Users.id — NOT NULL
  • name (Field) — string — NOT NULL
  • description (Field2) — string — NOT NULL

Positions (Untitled2)

  • id (Key) — string — Primary key — NOT NULL
  • user-id (Key2) — string — Foreign key → Users.id — NOT NULL
  • position (Field2) — string — NOT NULL

Schedules (Untitled10)

  • id (Key) — string — Primary key — NOT NULL

Users (Untitled)

  • id (Key) — string — Primary key — NOT NULL
  • student-id (Field2) — string — NOT NULL
  • name (Field) — string — NOT NULL
  • phone (Field3) — string
  • email (Field4) — string
  • github-username (Field5) — string
  • birthday (Field6) — date
  • admin (Field7) — boolean — NOT NULL

baekjoon (Untitled7)

  • username (Key) — string — Primary key — NOT NULL
  • user-id (Key2) — string — Foreign key → Users.id — NOT NULL
  • score (Field) — number — NOT NULL