erd
Tables (8)
T_APPLY
- num — NUMBER — Primary key
- classNum — NUMBER
- id — VARCHAR2(1000)
- merchant_uid — CLOB
- imp_uid — VARCHAR2(1000)
T_ATTACH
- uuid — VARCHAR2(1000) — Primary key — NOT NULL
- uploadPath — VARCHAR2(2000) — NOT NULL
- classNum — NUMBER
- fileName — VARCHAR2(1000) — NOT NULL
T_CLASS
- num — NUMBER — Primary key
- name — VARCHAR2(1000)
- title — VARCHAR2(1000)
- content — CLOB
- price — NUMBER
- place — VARCHAR2(1000)
- address — VARCHAR2(2000)
- headNum — NUMBER
- headCount — NUMBER
- openDate — DATE
- closeDate — DATE
- startTime — VARCHAR2(100)
- endTime — VARCHAR2(100)
- recruitDate — DATE
- recruitCloseDate — DATE
- regDate — DATE
- updateDate — DATE
T_HALL
- num — NUMBER
- name — VARCHAR2(500)
- CALL — VARCHAR2(500)
- sido — VARCHAR2(500)
- gugun — VARCHAR2(500)
- TYPE — NUMBER
T_INFO
- num — NUMBER
- name — VARCHAR2(1000)
- url — VARCHAR2(1000)
T_ITEM
- ITEMNUM — NUMBER(10)
- ITEMNAME — VARCHAR2(2000) — NOT NULL
- ITEMCONTENT — CLOB — NOT NULL
- USERID — VARCHAR2(2000)
- ITEMDELIVERPRICE — VARCHAR2(2000) — NOT NULL
- ITEMPRICE — VARCHAR2(2000) — NOT NULL
- ITEMTOTALCOUNT — VARCHAR2(2000) — NOT NULL
- ITEMHOME — VARCHAR2(2000) — NOT NULL
- ITEMREGDATE — DATE
- ITEMUPDATEDATE — DATE
T_RETURN
- NUM — NUMBER
- ITEM — VARCHAR2(1000)
- LOCAL — VARCHAR2(100)
- SIZE — NUMBER
- INPUT — NUMBER
- OPERATE — NUMBER
- INCOME — NUMBER
T_USER
- num — NUMBER — Primary key
- id — VARCHAR2(1000) — NOT NULL
- pw — VARCHAR2(1000) — NOT NULL
- name — VARCHAR2(1000) — NOT NULL
- phone — VARCHAR2(100) — NOT NULL
- email — VARCHAR2(1000) — NOT NULL
- address — VARCHAR2(2000)
- addressDetail — VARCHAR2(2000)
- status — NUMBER — NOT NULL