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