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