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)