2022_Project

Tables (10)

ACCOUNT

  • Key (ID) — int — Primary key — NOT NULL
  • Field (usrID) — char
  • Field (usrName) — char
  • Field (usrPassword) — char
  • Field (usrEmail) — text
  • Field (usrNickname) — char
  • Key (addID) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (ADDRESS)

  • Key (addID) — int — Primary key — NOT NULL
  • Field (addNickname) — char
  • Field (addName) — char
  • Field (addAddress) — text
  • Field (addPhone) — int
  • Field (addEtc) — text

Untitled (POST_EVALUATE)

  • Key (posteID) — int — Primary key — NOT NULL
  • Field (posteTitle) — char
  • Field (posteDetail) — text
  • Field (posteDate) — date
  • Field (posteModified) — date
  • Field (posteScore) — int
  • Key (writerID) — int — Foreign key → ACCOUNT.Key — NOT NULL

Untitled (REPLY_EVALUATE)

  • Key (reeID) — int — Primary key — NOT NULL
  • Field (reeDetail) — text
  • Field (reeDate) — date
  • Field (reeModified) — date
  • Field (reeScore) — int
  • Key (posteID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (ReplyID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (writerID) — int — Foreign key → ACCOUNT.Key — NOT NULL

Untitled (POST_SELL)

  • Key (postsID) — int — Primary key — NOT NULL
  • Field (postsTitle) — char
  • Field (postsDetail) — text
  • Field (postsDate) — date
  • Field (postsModified) — date
  • Field (postsPrice) — int
  • Field (postsQuantity) — int
  • Key (writerID) — int — Foreign key → ACCOUNT.Key — NOT NULL

Untitled (REPLY)

  • Key (reID) — int — Primary key — NOT NULL
  • Field (reDetail) — text
  • Field (reDate) — date
  • Field (reModified) — date
  • Field (reReply) — boolean
  • Key (postsID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (postID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (ReplyID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (writerID) — int — Foreign key → ACCOUNT.Key — NOT NULL

Untitled (POST)

  • Key (postID) — int — Primary key — NOT NULL
  • Field (postTitle) — char
  • Field (postDetail) — text
  • Field (postDate) — date
  • Field (postModified) — date
  • Key (writerID) — int — Foreign key → ACCOUNT.Key — NOT NULL

Untitled (OUTSOURCE)

  • Key (posteID) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (Metacritic) — int — Foreign key → Untitled.Field
  • Key (RottonTomato) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Metacritic)

  • Field (id) — int — Primary key
  • Field (score) — int

Untitled (RottonTomato)

  • Key (id) — int — Primary key — NOT NULL
  • Field (score) — int