be-simple
Tables (6)
Copy Of schedules (CopyOfschedules)
- id — INTEGER(11) — Primary key — NOT NULL
- partnerId — INTEGER(11) — Foreign key → partnerDetails.id — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
- day — ENUM('mon','tue','wed',...)
- time — TIME
Reservation
- id — INTEGER(11) — Primary key — NOT NULL
- userId — INTEGER(11) — Foreign key → userDetails.id — NOT NULL
- partnerId — INTEGER(11) — Foreign key → partnerDetails.id — NOT NULL
- startAt — DATETIME
- isend (endAt) — DATETIME
- roomId — MEDIUMTEXT
- note — VARCHAR(300)
partnerDetails
- id — INTEGER(11) — Primary key — NOT NULL
- partnerId — INTEGER(11) — Foreign key → users.id — NOT NULL
- name — VARCHAR(255)
- gender — TINYINT
- age — TINYINT
- phoneNumber — VARCHAR(255)
- url — VARCHAR(255)
- shortInfo (Field) — VARCHAR(255)
- career — TEXT
- info — TEXT
- chatCost — INTEGER
- keyword — VARCHAR(255)
- Field2
schedules
- id — INTEGER(11) — Primary key — NOT NULL
- userId — INTEGER(11) — Foreign key → userDetails.id — NOT NULL
- partnerId — INTEGER(11) — Foreign key → partnerDetails.id — NOT NULL
- roomId — MEDIUMTEXT
- startedAt — DATETIME
- createdAt — DATETIME
- updatedAt — DATETIME
- note — VARCHAR(300)
userDetails
- id — INTEGER(11) — Primary key — NOT NULL
- userId — INTEGER(11) — Foreign key → users.id — NOT NULL
- name — VARCHAR(20)
- gender — TINYINT(1)
- age — TINYINT(1)
- createdAt — DATETIME
- updatedAt — DATETIME
users
- id — INTEGER(11) — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- type — TINYINT
- createdAt — DATETIME
- updatedAt — DATETIME