saem7856
Tables (28)
announce (Untitled)
- anum (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- hitCount (Field5)
bbs (Untitled2)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- hitCount (Field5)
- notice (Field6)
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
bbslike (Untitled3)
- num (Key3) — PRIMARY KEY — Foreign key → bbs.num — NOT NULL
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
bbsreply (CopyOfUntitled)
- replynum (Key) — PRIMARY KEY — Primary key — NOT NULL
- content (Field3) — NN
- reg_date (Field4)
- answer (Field5)
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
- num (Key3) — PRIMARY KEY — Foreign key → bbs.num — NOT NULL
bbsreplylike (CopyOfUntitled3)
- replynum (Key3) — PRIMARY KEY — Foreign key → bbsreply.replynum — NOT NULL
- replylike (Field2)
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
contact (Untitled4)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- firtstname (Field) — NN
- lastname (Field2) — NN
- league (Field3)
- member (Field4)
- email (Field5) — NN
- comments (Field6) — NN
- reg_date (Field7)
contactcheck (Untitled5)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
fixture (Untitled6)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field) — NN
- color (Field2) — NN
- sday (Field3) — NN
- eday (Field4)
- stime (Field5)
- etime (Field6)
- memo (Field7)
gallery (CopyOfUntitled2)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- hitCount (Field5)
galphotofile (Untitled7)
- filenum (Key) — PRIMARY KEY — Primary key — NOT NULL
- num (Field)
- imagefilename (Field2)
gdsphotofile (CopyOfUntitled7)
- filenum (Key) — PRIMARY KEY — Primary key — NOT NULL
- num (Field)
- imagefilename (Field2)
goods (CopyOfCopyOfUntitled2)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- hitCount (Field5)
member1 (Untitled8)
- userId (Key) — PRIMARY KEY — Primary key — NOT NULL
- userName (Field) — NN
- userPwd (Field2) — NN
- enabled (Field3)
- register_Date (Field4)
- modify_Date (Field5)
member2 (CopyOfUntitled8)
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
- birth (Field)
- email (Field2)
- tel (Field3)
- zip (Field4)
- addr1 (Field5)
- addr2 (Field6)
news (CopyOfCopyOfUntitled22)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- hitCount (Field5)
- link (Field) — NN
- imageFileName (Field6)
newslike (CopyOfUntitled32)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
photolike (CopyOfCopyOfUntitled32)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
photoreply (CopyOfCopyOfUntitled)
- replynum (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
- content (Field3) — NN
- reg_date (Field4)
- answer (Field5)
- num (Field6)
photoreplylike (CopyOfCopyOfUntitled3)
- replynum (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
- replylike (Field2)
player (CopyOfCopyOfCopyOfUntitled22)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- imageFileName (Field6) — NN
- league (Field7) — NN
- team (Field8) — NN
- content2 (Field9)
- content3 (Field5)
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
review (CopyOfUntitled4)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- hitCount (Field5)
- gdsNum (Field6)
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
reviewlike (CopyOfCopyOfCopyOfUntitled32)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
reviewreply (CopyOfCopyOfCopyOfUntitled)
- replynum (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
- content (Field3) — NN
- reg_date (Field4)
- answer (Field5)
- num (Field6)
reviewreplylike (CopyOfCopyOfUntitled33)
- replynum (Key) — PRIMARY KEY — Primary key — NOT NULL
- userId (Field) — NN
- replylike (Field2)
revphotofile (CopyOfCopyOfUntitled7)
- filenum (Key) — PRIMARY KEY — Primary key — NOT NULL
- num (Field)
- imagefilename (Field2)
trade (CopyOfCopyOfUntitled4)
- num (Key) — PRIMARY KEY — Primary key — NOT NULL
- subject (Field2) — NN
- content (Field3) — NN
- reg_date (Field4)
- hitCount (Field5)
- type (Field6) — NN
- pay (Field7)
- userId (Key2) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL
tradefile (CopyOfCopyOfCopyOfUntitled7)
- filenum (Key) — PRIMARY KEY — Primary key — NOT NULL
- num (Field)
- imagefilename (Field2)
tradereply (CopyOfCopyOfCopyOfCopyOfUntitled)
- replynum (Key) — PRIMARY KEY — Primary key — NOT NULL
- content (Field3) — NN
- reg_date (Field4)
- answer (Field5)
- num (Key2) — PRIMARY KEY — Foreign key → trade.num — NOT NULL
- userId (Key3) — PRIMARY KEY — Foreign key → member1.userId — NOT NULL