dn lab

Tables (11)

Application (Untitled3)

  • num (Key) — int — Primary key — NOT NULL
  • motive (Field) — TEXT
  • intro (Field2) — TEXT
  • wanted (Field3) — TEXT
  • status (Field4) — ENUM
  • creatdAt (Field5) — date
  • updatedaAt (Field6) — date
  • num (Key2) — int — Foreign key → User.num — NOT NULL

Attendance (Untitled2)

  • num (Key) — int — Primary key — NOT NULL
  • status (Field) — ENUM
  • starttime (Field2) — date
  • num (Key2) — int — Foreign key → User.num — NOT NULL

Board (Untitled6)

  • num (Key) — int — Primary key — NOT NULL
  • name (Field) — String
  • description (Field2) — TEXT

Book (Untitled10)

  • num (Key) — int — Primary key — NOT NULL
  • title (Field) — TEXT
  • author (Field2) — String
  • borrowYN (Field3) — bool

Comment (Untitled7)

  • num (Key) — int — Primary key — NOT NULL
  • content (Field) — TEXT
  • createdAt (Field2) — date
  • updatedAt (Field3) — date
  • num (postNum) — int — Foreign key → Post.num — NOT NULL
  • num (userNum) — int — Foreign key → User.num — NOT NULL

Equipment (Untitled8)

  • num (Key) — int — Primary key — NOT NULL
  • name (Field) — String
  • purchase_date (Field2) — date
  • price (Field3) — int
  • usingYN (Field4) — bool

Post (Untitled5)

  • num (Key) — int — Primary key — NOT NULL
  • title (Field) — TEXT
  • CONTENT (Field2) — TEXT
  • createdAt (Field3) — date
  • updatedAt (Field4) — date
  • num (BoardNum) — int — Foreign key → Board.num — NOT NULL
  • num (UserNum) — int — Foreign key → User.num — NOT NULL

Rental (Untitled11)

  • num (Key) — int — Primary key — NOT NULL
  • rent_start_date (Field) — date
  • rent_end_date (Field2) — date
  • num (userNum) — int — Foreign key → User.num — NOT NULL
  • num (bookNum) — int — Foreign key → Book.num — NOT NULL

Todo (Untitled4)

  • num (Key) — int — Primary key — NOT NULL
  • content (Field) — TEXT
  • week_start_date (Field2) — date
  • status (Field3) — ENUM
  • createdAt (Field4) — date
  • num (Key2) — int — Foreign key → User.num — NOT NULL

User (Untitled)

  • num (Key) — int — Primary key — NOT NULL
  • name (Field) — String
  • id (Field2) — String
  • pw (Field3) — String
  • StudentId (Field4) — int
  • generation (Field5) — int
  • leaderYN (Field6) — bool
  • graduateYN (Field7) — bool

Using (Untitled9)

  • num (Key) — int — Primary key — NOT NULL
  • using_start_date (Field) — date
  • using_end__date (Field2) — date
  • num (equipmentNum) — int — Foreign key → Equipment.num — NOT NULL
  • num (userNum) — int — Foreign key → User.num — NOT NULL