B303
Tables (15)
Animal (동물)
- AnimalId (animalId) — VARCHAR(100) — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
- Picture (picture) — VARCHAR(500)
- Specie (specie) — VARCHAR(100)
- Age (age) — VARCHAR(10)
- Note (note) — VARCHAR(1000)
- Weight (weight) — DECIMAL
- Gender (gender) — VARCHAR(10)
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
ExpertUser (전문가)
- LicenseNumber (license) — VARCHAR(20) — Primary key
- Note (note) — VARCHAR(1000)
- StartTime (startTime) — TIME
- EndTime (endTime) — TIME
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
- HospitalNo (hosno) — INT — Foreign key → HospitalData.HospitalNo
HospitalData (동물병원 정보)
- HospitalNo (hosno) — INT — Primary key
- ManageNo (manageno) — INT
- Phone (phone) — VARCHAR(30)
- LotNumberAddress (lotAddr) — VARCHAR(500)
- RoadNumberAddress (roadAddr) — VARCHAR(500)
- PostalNumber (posNum) — INT
- Name (name) — VARCHAR(200)
- Longitude (long) — VARCHAR(100)
- Latitude (lat) — VARCHAR(100)
Messages (쪽지)
- MessageId (mesId) — INT — Primary key — NOT NULL
- Time (time) — DATETIME
- Title (title) — VARCHAR(200)
- Content (content) — VARCHAR(1000)
- From (from) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
- To (to) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
ParticipantHistory (참여기록)
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
- RoomId (roomId) — VARCHAR(100) — Foreign key → VideoRoom.RoomId — NOT NULL
- EnterTime (enterTime) — DATETIME
PostComment (게시판댓글)
- CommentNo (commentNo) — INT — Primary key — NOT NULL
- Content (content) — VARCHAR(1000)
- RegistTime (registTime) — DATETIME
- PostId (postId) — VARCHAR(100) — Foreign key → UserPost.PostId — NOT NULL
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
PostFiles (게시판파일)
- URL (url) — VARCHAR(1000)
- FileName (fileName) — VARCHAR(200)
- PostId (postId) — VARCHAR(100) — Foreign key → UserPost.PostId — NOT NULL
QnABoard (QnA게시판)
- PostId (postId) — VARCHAR(100) — Primary key — NOT NULL
- Title (title) — VARCHAR(200)
- Content (content) — VARCHAR(1000)
- RegistTime (registTime) — DATETIME
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
Reservation (예약)
- AppointId (appointId) — VARCHAR(100) — Primary key — NOT NULL
- Time (time) — DATETIME
- Diagnosis (diagnosis) — VARCHAR(1000) — NOT NULL
- Note (note) — VARCHAR(1000)
- Type (type) — INT
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
- LicenseNumber (license) — VARCHAR(20) — Foreign key → ExpertUser.LicenseNumber
- HospitalNo (hosno) — INT — Foreign key → HospitalData.HospitalNo
User (사용자)
- UserId (userId) — VARCHAR(100) — Primary key — NOT NULL
- Password (password) — VARCHAR(50)
- UserName (username) — VARCHAR(50)
- Address (address) — VARCHAR(500)
- Phone (phone) — VARCHAR(20)
- Type (type) — INT
- Picture (picture) — VARCHAR(500)
UserPost (자유게시판)
- PostId (postId) — VARCHAR(100) — Primary key — NOT NULL
- Hits (hits) — INT
- Content (content) — VARCHAR(1000)
- Likes (likes) — INT
- RegistTime (registTime) — DATETIME
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
VenueData (편의시설 정보)
- DataNo (datano) — INT — Primary key — NOT NULL
- VenueName (venName) — VARCHAR(100)
- Category (category) — VARCHAR(50)
- Sido (sido) — VARCHAR(50)
- Gungu (gungu) — VARCHAR(50)
- MyunDong (myundong) — VARCHAR(50)
- Latitude (lat) — DECIMAL
- Longitude (long) — DECIMAL
- PostalNumber (posNum) — INT
- RoadNumberAddress (roadAddr) — VARCHAR(500)
- LotNumberAddress (lotAddr) — VARCHAR(500)
- Phone (phone) — VARCHAR(30)
- HomePage (homepage) — VARCHAR(200)
- OffTime (offTime) — VARCHAR(200)
- WorkTime (workTime) — VARCHAR(200)
- ParkingAvailability (parkAvail) — CHAR(4)
- EntranceAvailibility (entrAvail) — VARCHAR(100)
- Limitations (limit) — VARCHAR(100)
Verification (인증정보)
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL
- VerificationCode (verCode) — VARCHAR(10)
- CodeTimer (codeTime) — DATETIME
VideoChatLog (화상채팅기록)
- RoomId (roomId) — VARCHAR(100) — Foreign key → VideoRoom.RoomId — NOT NULL
- URL (url) — VARCHAR(1000)
VideoRoom (화상 방 정보)
- RoomId (roomId) — VARCHAR(100) — Primary key — NOT NULL
- StartTime (startTime) — DATETIME
- RoomName (roomName) — VARCHAR(100)
- Note (note) — VARCHAR(1000)
- UserId (userId) — VARCHAR(100) — Foreign key → User.UserId — NOT NULL