aiservicelab-refact2

Tables (6)

likes

  • likeid — int — Primary key
  • postid (postid2) — int — Foreign key → post.postid
  • writer (userid) — int — Foreign key → post.writer
  • postid — int — NOT NULL
  • liker — int — NOT NULL
  • createdAt — timestamp

notice

  • noticeid — int — Primary key
  • writer (userid) — int — Foreign key → user.userid
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • writer — int — NOT NULL
  • views — int
  • img — varchar(255)
  • createdAt — datetime

plan

  • planid — int — Primary key
  • userid — int — Foreign key → user.userid
  • writer — int — NOT NULL
  • date — date — NOT NULL
  • contents — text — NOT NULL

post

  • postid — int — Primary key
  • writer (userid) — int — Foreign key → user.userid
  • contents — text — NOT NULL
  • createdAt — timestamp

project

  • projectid — int — Primary key
  • writer (userid) — int — Foreign key → user.userid
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • link — varchar(2048) — NOT NULL
  • writer — int — NOT NULL
  • createdAt — timestamp
  • img — varchar(255)

user

  • userid — int — Primary key
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • pwd — varchar(255) — NOT NULL
  • question — varchar(255) — NOT NULL
  • answer — varchar(255) — NOT NULL
  • master — tinyint(1)
  • session_id — varchar(255)