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)