behint_web_demo

Tables (23)

Agreement (Untitled2)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • termOfService — bool
  • personalInformation — bool
  • eventReceive — bool
  • createdAt (Field) — datetime
  • updatedAt (Field2) — datetime

Alarm (Untitled16)

  • userId (id) — int — Foreign key → User.id — NOT NULL
  • 1 (Field) — bool
  • 2 (Field2) — bool
  • 3 (Field3) — bool
  • 4 (Field4) — bool
  • 5 (Field5) — bool
  • createdAt (Field6) — datetime
  • updatedAt (Field7) — datetime

Ban (Untitled22)

  • senderId (id) — int — Foreign key → User.id — NOT NULL
  • receiverId (id2) — int — Foreign key → User.id — NOT NULL
  • createdAt (Field) — datetime

Commentary (Untitled10)

  • id — int — Primary key — NOT NULL
  • projectId — int — Foreign key → Project.id — NOT NULL
  • title — varchar(128)
  • startTime — time
  • endTime — time
  • thumbnailImgUrl — text

CommentaryContents (Untitled11)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • commentId — int — Foreign key → Commentary.id — NOT NULL
  • content — text

CommentaryLike (Untitled12)

  • contentId — int — Foreign key → CommentaryContents.id — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL

Contract (Untitled20)

  • id (Key) — int — Primary key — NOT NULL
  • proposalId (Key2) — int — Foreign key → Proposal.id — NOT NULL
  • fileName (Field) — text
  • fileUrl (Field2) — text

Follow (Untitled13)

  • followerId (id) — int — Foreign key → User.id — NOT NULL
  • followingId (id2) — int — Foreign key → User.id — NOT NULL

Location (Untitled8)

  • id — int — Primary key — NOT NULL
  • projectId — int — Foreign key → Project.id — NOT NULL
  • locationName — varchar(256)
  • latitude — decimal
  • longitude — decimal

Message (Untitled18)

  • id (Key2) — int — Primary key — NOT NULL
  • roomId (Key) — int — Foreign key → MessageRoom.id — NOT NULL
  • ReciverId (id) — int — Foreign key → MessageRoom.ReciverId — NOT NULL
  • SenderId (id2) — int — Foreign key → MessageRoom.ReciverId — NOT NULL
  • content (Field) — text
  • check (Field2) — bool

MessageRoom (Untitled17)

  • id (Key) — int — Primary key — NOT NULL
  • ReciverId (id) — int — Foreign key → User.id — NOT NULL
  • SenderId (id2) — int — Foreign key → User.id — NOT NULL
  • accept (Field) — bool
  • reciverOut (Field2) — bool
  • senderOut (Field3) — bool
  • reciverReport (Field4) — bool
  • senderReport (Field5) — bool

Profile (Untitled)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • nickname — varchar(20)
  • job — varchar(20)
  • location — varchar(20)
  • profileImgUrl — text
  • introduce — text
  • instagramUrl — text
  • facebookUrl — text
  • tweeterUrl — text
  • etcUrl — text
  • mainProjects — text
  • createdAt (Field) — datetime
  • deletedAt (Field2) — datetime

Project (Untitled4)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • videoUrl — text
  • thumbnailImgUrl — text
  • title — varchar(128)
  • introduce — text
  • copyright — varchar(64)
  • position — varchar(64)
  • viewCount — int
  • visible — bool
  • category — varchar(64)

ProjectLike (Untitled7)

  • userId — int — Foreign key → User.id — NOT NULL
  • projectId — int — Foreign key → Project.id — NOT NULL
  • type — varchar(64)

ProjectMember (Untitled9)

  • email — text — Primary key — NOT NULL
  • projectId — int — Foreign key → Project.id — NOT NULL
  • signup (signUp) — bool
  • accept — bool
  • position — varchar(64)

ProjectTag (Untitled6)

  • projectId — int — Foreign key → Project.id — NOT NULL
  • tagId — int — Foreign key → Tag.id — NOT NULL
  • email — text — Foreign key → ProjectMember.email — NOT NULL

Proposal (Untitled19)

  • id (Key2) — int — Primary key — NOT NULL
  • roomId (Key) — roomId — Foreign key → MessageRoom.id — NOT NULL
  • totle (Field) — varchar(128)
  • period (Field2) — varchar(128)
  • contnet (Field3) — text
  • cost (Field4) — int
  • evidence (Field5) — varchar(128)
  • type (Field6) — varchar(64)

Report (Untitled21)

  • id (Key) — int — Primary key — NOT NULL
  • senderId (id) — int — Foreign key → User.id — NOT NULL
  • receiverId (id2) — int — Foreign key → User.id — NOT NULL
  • type (Field) — varchar(64)
  • content (Field2) — text
  • condition (Field3) — bool

Scrap (Untitled14)

  • id (Key) — int — Primary key — NOT NULL
  • userId (id) — int — Foreign key → User.id — NOT NULL
  • name (Field) — varchar(128)
  • visible (Field2) — bool

ScrapProject (Untitled15)

  • id (Key2) — int — Primary key — NOT NULL
  • scrapId (Key) — int — Foreign key → Scrap.id — NOT NULL
  • projectId (id2) — int — Foreign key → Project.id — NOT NULL
  • visible (Field) — bool

Tag (Untitled5)

  • id — int — Primary key — NOT NULL
  • content — varchar(128)

User

  • id — int — Primary key — NOT NULL
  • email — text — NOT NULL
  • provider — varchar(32) — NOT NULL
  • deletedAt (withdraw) — datetime
  • createdAt (Field) — datetime

UserInformation (Untitled3)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • title — varchar(64) — NOT NULL
  • startDate — datetime
  • endDate — datetime
  • position — varchar(64)
  • detailContents — text
  • informationUrl — text
  • createdAt (Field) — datetime
  • deletedAt (Field2) — datetime