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)