onion1
Tables (18)
Bizcategory
- id — number
- Bizcategory — VARCHAR(255)
- groupseq — number
Boardcategory
- id — number
- Boardcategory — VARCHAR(255)
- Boardcategoryimg — varchar(4000)
- groupseq — number
Categorygroups
- groupseq — number
- groupname — VARCHAR(255)
CommunityPost
- PostSeq — NUMBER
- Clike — NUMBER — NOT NULL
- Chate — NUMBER — NOT NULL
FoodCategory
- FCseq — NUMBER
- FCEnking — VARCHAR2(50) — NOT NULL
- FCkind — VARCHAR2(50)NOT — NOT NULL
- FCname — VARCHAR2(50) — NOT NULL
Jobboard
- JBid — VARCHAR2(30) — NOT NULL
- JBseq — number
- JBsub — varchar2(100) — NOT NULL
- JBcon — varchar(100) — NOT NULL
- JBPeoplenum — number
- JBWorkingdate — varchar2(1000)
- JBWorkinghours — varchar2(1000)
- JBEnddate — varchar2(1000)
- JBSalarytype — varchar2(1000)
- JBSalary — number
- is_available — NUMBER(1)
- JBlogtime — Date
Menuitems
- MIid — VARCHAR(30) — NOT NULL
- MIseq — number
- MIitemname — VARCHAR(100) — NOT NULL
- MIprice — VARCHAR(100) — NOT NULL
- MIimg — VARCHAR(4000)
- MIhit — number
- is_available — NUMBER(1)
- MIlogtime — date
SaleUser
- Saleid — varchar2(30)
- Saletel — varchar2(20)not — NOT NULL
- Salepwd — varchar2(100) — NOT NULL
- Saleemail — varchar2(100) — NOT NULL
- SaleCEO — varchar2(100) — NOT NULL
- Salecompanyname — varchar2(100) — NOT NULL
- SaleStorename — varchar2(100) — NOT NULL
- Salestoretel — varchar(20) — NOT NULL
- Saleurl — varchar2(4000)
- Salecategory — varchar(200) — NOT NULL
- Saleimage — varchar2(4000) — NOT NULL
- Saleopen — varchar2(10) — NOT NULL
- Saleclose — varchar2(10) — NOT NULL
- SalebusinessNum — varchar2(100) — NOT NULL
- Saleaddress — varchar2(4000) — NOT NULL
- Salebusinessimg — varchar(4000) — NOT NULL
- Salelogtime — date
Saleboard
- SBid — VARCHAR2(30) — NOT NULL
- SBseq — number
- SBsubject — VARCHAR2(30) — NOT NULL
- SBcontent — VARCHAR2(4000) — NOT NULL
- SBimg — VARCHAR2(4000)
- is_available — NUMBER(1)
- SBlogtime — date
banner
- id — NUMBER
- image_url — VARCHAR2(255) — NOT NULL
- title — VARCHAR2(255)
- description — CLOB
- is_active — NUMBER(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
boardInfo
- Bseq — number
- Bid — varchar2(30) — NOT NULL
- Bname — varchar2(30) — NOT NULL
- Bsub — varchar2(255) — NOT NULL
- Bcon — varchar2(4000) — NOT NULL
- BPrc — varchar2(255) — NOT NULL
- Bcategory — varchar2(100) — NOT NULL
- Bimg — varchar2(100) — NOT NULL
- Blike — number — NOT NULL
- Bjjim — number — NOT NULL
- Bhit — number — NOT NULL
- Blogtime — date
chatmessage
- CMmsgnum — NUMBER
- CMroomnum — NUMBER
- CMsendid — VARCHAR2(15)
- CMsendmsg — VARCHAR2(999)
- CMsendtime — DATE
chatroom
- CRroomnum — NUMBER
- CRsendid — VARCHAR2(15)
- CRrecid — VARCHAR2(15)
- CRlogtime — DATE
comments
- comment_id — NUMBER
- community_id — NUMBER
- user_id — VARCHAR2(50)
- content — VARCHAR2(1000)
- logtime — DATE
community
- Cseq — number
- Cid — varchar2(30) — NOT NULL
- Cname — varchar2(30) — NOT NULL
- Csub — varchar2(255) — NOT NULL
- Ccon — varchar2(4000) — NOT NULL
- Cimg — varchar2(100)
- Clike — number — NOT NULL
- Chate — number — NOT NULL
- Chit — number — NOT NULL
- Clogtime — date
manager
- Mid — varchar2(300)
- Mpwd — varchar2(300)
- Mlogtime — Date
- role — VARCHAR2(255 CHAR)
manager_board
- MBseq — number — NOT NULL
- MBid — varchar2(30) — NOT NULL
- MBsub — varchar2(255) — NOT NULL
- MBcon — varchar2(4000) — NOT NULL
- MBimg — varchar2(200)
- MBhit — number
- MBlogtime — date
userInfo
- Userid — VARCHAR2(15)
- Uname — VARCHAR2(50) — NOT NULL
- Upwd — VARCHAR2(200) — NOT NULL
- Ugender — VARCHAR2(10) — NOT NULL
- Ujumin1 — VARCHAR2(13) — NOT NULL
- Ujumin2 — VARCHAR2(13) — NOT NULL
- Utel1 — VARCHAR2(5) — NOT NULL
- Utel2 — VARCHAR2(4) — NOT NULL
- Utel3 — VARCHAR2(4) — NOT NULL
- Uaddr — VARCHAR2(100) — NOT NULL
- Uemail1 — VARCHAR2(50) — NOT NULL
- Uemail2 — VARCHAR2(50) — NOT NULL
- Ulogtime — DATE
- is_active — CHAR(1)
- last_login_time — DATE
- profile_image — VARCHAR2(255)
- role — VARCHAR2(50) — NOT NULL