D_TABAI

Tables (15)

Book (Untitled5)

  • seq (BookSeq) — Primary key — NOT NULL
  • ID (UserId) — Foreign key → Member.ID — NOT NULL
  • seq (MarketSeq) — Foreign key → Market.seq — NOT NULL
  • Time (BookTime)
  • Name (UserName)
  • many (HowMany)

Chat (Untitled15)

  • Seq (RoomSeq) — Foreign key → ChatRoom.Seq — NOT NULL
  • ID (UserId) — Foreign key → ChatRoom.ID — NOT NULL
  • Chat (ChatContent)

ChatRoom (Untitled14)

  • Seq (RoomSeq) — Primary key — NOT NULL
  • ID (UserId) — Foreign key → Member.ID — NOT NULL
  • HowMany? (People)
  • Title (RoomTitle)
  • Subject (RoomSubject)
  • Field

Comment (Untitled16)

  • Seq (CommentSeq) — Primary key — NOT NULL
  • Seq (CommunitySeq) — Foreign key → Community.Seq — NOT NULL
  • ID (UserId) — Foreign key → Community.ID — NOT NULL
  • title (CommentTitle)
  • content (CommentContent)

Community (Untitled13)

  • Seq (CommunitySeq) — Primary key — NOT NULL
  • ID (UserId) — Foreign key → Member.ID — NOT NULL
  • Title (CommunityTitle)
  • Content (CommunityComment)
  • date (Indate)

Location (Untitled4)

  • seq (MarketSeq) — Foreign key → Market.seq — NOT NULL
  • Lat
  • lng (Lng)

MailBridge (Untitled11)

  • seq (BridgeSeq) — Primary key — NOT NULL
  • Seq (MailSeq) — Foreign key → Mailbox.Seq — NOT NULL
  • Seq (MailFileSeq) — Foreign key → MailFileBox.Seq — NOT NULL

MailFileBox (Untitled12)

  • Seq (MailFileSeq) — Primary key — NOT NULL
  • Url (FileUrl)
  • Url (SavedUrl)

Mailbox (Untitled10)

  • Seq (MailSeq) — Primary key — NOT NULL
  • ID (ToUser) — Foreign key → Member.ID — NOT NULL
  • ID (FromUser) — Foreign key → Member.ID — NOT NULL
  • title (MailTitle)
  • Content (MailContent)
  • Type (MailType)
  • File (MailFile)
  • date (indate)

Market (Untitled2)

  • seq (MarketSeq) — Primary key — NOT NULL
  • name (MarketName)
  • hit (MarketHit)
  • title (MarketTitle)
  • content (MarketContent)
  • point (marketPoint)
  • kind (marketKind)
  • Delete (Deleted)
  • Limit (marketBookLimit)

MarketImg (Untitled9)

  • seq (MarketSeq) — Foreign key → Market.seq — NOT NULL
  • FileName
  • SavedName

MarketTimeTable (Untitled8)

  • seq (MarketSeq) — Foreign key → Market.seq — NOT NULL
  • Time (Open)
  • Time (Close)
  • Time (Rest)
  • Time (BreakTime)

Member (Untitled)

  • ID (UserId) — Primary key — NOT NULL
  • pw (UserPw)
  • NAME (UserName)
  • Phone (userPhone)
  • admin (Admin)
  • delete (Delete)

Review (Untitled3)

  • seq (ReviewSeq) — Primary key — NOT NULL
  • seq (MarketSeq) — Foreign key → Market.seq — NOT NULL
  • ID (UserId) — Foreign key → Member.ID — NOT NULL
  • title (ReviewTitle)
  • content (ReviewContent)
  • point (ReviewPoint)

menu (Untitled6)

  • Key (MenuSeq) — Primary key — NOT NULL
  • seq (MarketSeq) — Foreign key → Market.seq — NOT NULL
  • Kind (MenuKind)
  • Name (MenuName)
  • price (MenuPrice)