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