test
Tables (7)
consult
- consultId — int — Primary key — NOT NULL
- userId — int — Foreign key → user.userId — NOT NULL
- docId — int — Foreign key → doc.docId — NOT NULL
- estimate — int
- consultImg — varchar(255) — NOT NULL
- consultContent — varchar(255)
consult_image
- consultId — int — Foreign key → consult.consultId — NOT NULL
- userId — int — Foreign key → consult.userId — NOT NULL
- docId — int — Foreign key → consult.docId — NOT NULL
- imageId — int
- fileName — varchar(255)
doc
- docId — int — Primary key — NOT NULL
- userId — int — Foreign key → user.userId — NOT NULL
- introduce — varchar(100)
- imageId — varchar(255)
- hospitalName — varchar(30)
- hospitalAddress — varchar(50)
- major — varchar(20)
- possibleField — int
- possibleWeek — int
- possibleTime — dateTime
- rating — VARCHAR(255)
doc_image
- docId — int — Foreign key → doc.docId — NOT NULL
- userId — int — Foreign key → doc.userId — NOT NULL
- imageId — int
- fileName — varchar(255)
favorites
- favoritesId — int — Primary key — NOT NULL
- userId — int — Foreign key → user.userId — NOT NULL
- docId — int — Foreign key → doc.docId — NOT NULL
review
- reviewId — int — Primary key — NOT NULL
- userId — int — Foreign key → user.userId — NOT NULL
- consultId — int
- docId — int
- rating — int
user
- userId — int — Primary key — NOT NULL
- email — varchar(50)
- password — varchar(200)
- birth — date
- gender — char
- phone — varchar(20)
- type — char
- isValid — int