Place

Tables (7)

Comment (CopyOfUntitled22)

  • commentIdx (Key) — long — Primary key — NOT NULL
  • storyIdx (Key2) — long — Foreign key → Story.storyIdx — NOT NULL
  • userIdx (Key3) — long — Foreign key → User.userIdx — NOT NULL
  • content (Field) — varchar(255) — NOT NULL
  • created_date (Field2) — LocalDateTime — NOT NULL
  • updated_date (Field3) — LocalDateTime — NOT NULL
  • status (Field4) — varchar(10) — NOT NULL

Exhibition (Untitled)

  • exhibitionIdx (Key) — long — Primary key — NOT NULL
  • exhibitionName (Field2) — varchar(30) — NOT NULL
  • exhibitionImg (Field3) — image
  • startDate (Field4) — LocalDateTime — NOT NULL
  • endDate (Field5) — LocalDateTime — NOT NULL
  • operatingTime (Field6) — varchar(255) — NOT NULL
  • location (Field7) — varchar(255) — NOT NULL
  • fee (Field8) — long
  • artist (Field9) — varchar(255) — NOT NULL
  • category (Field10) — enum — NOT NULL
  • created_date (Field11) — LocalDateTime — NOT NULL
  • updated_date (Field12) — LocalDateTime — NOT NULL
  • status (Field13) — varchar(10) — NOT NULL

ExhibitionLike (Untitled2)

  • exhibitionLikeIdx (Key) — long — Primary key — NOT NULL
  • exhibitionIdx (Key2) — long — Foreign key → Exhibition.exhibitionIdx — NOT NULL
  • userIdx (Key3) — long — Foreign key → User.userIdx — NOT NULL
  • created_date (Field) — LocalDateTime — NOT NULL
  • updated_date (Field2) — LocalDateTime — NOT NULL
  • status (Field3) — varchar(10) — NOT NULL

Review (CopyOfUntitled25)

  • reviewIdx (Key) — long — Primary key — NOT NULL
  • content (Field) — string
  • score (Field2) — string
  • created_date (Field3) — LocalDateTime
  • updated_date (Field4) — LocalDateTime
  • status (Field5) — string

Story (CopyOfUntitled2)

  • storyIdx (Key) — long — Primary key — NOT NULL
  • userIdx (Key2) — long — Foreign key → User.userIdx — NOT NULL
  • exhibitionIdx (Key3) — long — Foreign key → Exhibition.exhibitionIdx — NOT NULL
  • storyImg (Field) — image
  • created_date (Field2) — LocalDateTime — NOT NULL
  • updated_date (Field3) — LocalDateTime — NOT NULL
  • status (Field4) — varchar(10) — NOT NULL

StoryLike (CopyOfUntitled23)

  • storyLikeIdx (Key) — long — Primary key — NOT NULL
  • userIdx (Key2) — long — Foreign key → User.userIdx — NOT NULL
  • storyIdx (Key3) — long — Foreign key → Story.storyIdx — NOT NULL
  • created_date (Field) — LocalDateTime — NOT NULL
  • updated_date (Field2) — LocalDateTime — NOT NULL
  • status (Field3) — varchar(10) — NOT NULL
  • Field4

User (CopyOfUntitled24)

  • userIdx (Key) — long — Primary key — NOT NULL
  • nickname (Field) — varchar(10) — NOT NULL
  • location (Field2) — varchar(255) — NOT NULL
  • userImg (Field3) — image
  • provider (Field4) — enum — NOT NULL
  • refreshToken (Field5) — varchar(255) — NOT NULL
  • created_date (Field6) — LocalDateTime — NOT NULL
  • updated_date (Field7) — LocalDateTime — NOT NULL
  • status (Field8) — varchar(255) — NOT NULL