week4Study
Tables (7)
Inquiry (문의)
- InquiryID (Key2) — Primary key — NOT NULL
- memberID (Key) — Long — Foreign key → Member.memberID — NOT NULL
- title (Field) — varchar(50)
- type (Field2) — varchar(50)
- content (Field3) — varchar(100)
- photo (Field4) — BLOB
- writtenTime (Field5) — varchar(50)
- replied (Field6) — Boolean
Member (회원정보)
- memberID (Key) — Long — Primary key — NOT NULL
- isAuthenticated (Field) — Boolean
- point (Field8) — Int
- memberName (Field2) — varchar(50)
- sex (Field3) — varchar(50)
- birth (Field4) — varchar(50)
- address (Field5) — varchar(50)
- email (Field6) — varchar(50)
- phoneNumber (Field7) — varchar(50)
- preferedFood (Field9) — Array
- nickname (Field10) — varchar(50)
MissionList (Untitled2)
- authNumber (Key) — Long — Foreign key → Restaurant.authNumber — NOT NULL
- memberID (Key2) — Long — Foreign key → MyMission.memberID — NOT NULL
- givenPoint (Field2) — Int
- dday (Field) — Int
- success (Field3) — Boolean
- state (Field4) — varchar(10)
MyMission (Untitled)
- memberID (Key) — Long — Foreign key → Member.memberID — NOT NULL
- successCount (Field) — Int
- givenPoint (Field2) — Int
Restaurant (식당정보)
- authNumber (Key) — Long — Primary key — NOT NULL
- restaurantName (Field) — varchar(50)
- restaurantType (Field2) — varchar(50)
- address (Field3) — varchar(50)
- photo (Field4) — BLOB
- open (Field5) — Boolean
- star (Field6) — Float
- Field7
Review (리뷰)
- restaurantID (Key2) — Long — Foreign key → Restaurant.authNumber — NOT NULL
- memberID (Key3) — Long — Foreign key → Member.memberID — NOT NULL
- date (Field) — varchar(50)
- reviewStar (Field2) — Float
- comment (Field3) — varchar(100)
- reviewphoto (Field4) — BLOB
ReviewReply (리뷰댓글)
- restaurantID (Key2) — Foreign key → Review.restaurantID — NOT NULL
- memberID (Key3) — Long — Foreign key → Review.memberID — NOT NULL
- repliedDate (Field) — varchar(50)
- repliedComment (Field2) — varchar(100)