tradecollab
Tables (20)
BRANCH
- bNum — INT — Primary key — NOT NULL
- bName — varchar(20) — NOT NULL
- bAddress — varchar(100) — NOT NULL
- bPhone — varchar(20) — NOT NULL
- bAuth — varchar(10) — NOT NULL
- Lat — double — NOT NULL
- Lng — double — NOT NULL
ItemList
- ItemNum — INT — Primary key — NOT NULL
- Category — VARCHAR(255)
- ItemName — VARCHAR(255)
- Manufacturer — VARCHAR(255)
- Price — DECIMAL(10, 2)
- URL — VARCHAR(255)
MESSAGE
- MNO — INT — Primary key — NOT NULL
- SENDER — INT — NOT NULL
- LISTENER — INT — NOT NULL
- MTITLE — VARCHAR(100) — NOT NULL
- MCONTENT — VARCHAR(500) — NOT NULL
- DATE_SENT — DATETIME — NOT NULL
- READ_OR_NOT — INT
- DATE_READ — DATETIME
MESSAGE_STATUS
- MNO — INT — Primary key — NOT NULL
- DELETED_BY — INT — NOT NULL
- IS_DELETED_BY — INT
PurchaseOrder
- PurchaseNum — INT — Primary key — NOT NULL
- ItemNum — INT
- Quantity — INT
- PurchaseDate — DATE
- ReceiptDate — DATE
STOCK_B
- Sno — INT — Primary key — NOT NULL
- ItemNum — int — NOT NULL
- pStock — int — NOT NULL
- IcDate — datetime — NOT NULL
- bNum — int — NOT NULL
STOCK_W
- Sno — INT — Primary key — NOT NULL
- ItemNum — int — NOT NULL
- pStock — int — NOT NULL
- IcDate — datetime — NOT NULL
- wNum — int — NOT NULL
WAREHOUSE
- wNum — INT — Primary key — NOT NULL
- wName — varchar(20) — NOT NULL
- wAddress — varchar(100) — NOT NULL
- wPhone — varchar(20) — NOT NULL
- wAuth — varchar(10) — NOT NULL
- Lat — double — NOT NULL
- Lng — double — NOT NULL
approval
- board_id — int — Primary key — NOT NULL
- pass — varchar(20)
- dept_no — int
- member_name — varchar(20)
- member_no — int
- job1 — int
- member_name2 — varchar(20)
- member_no2 — int
- job2 — int
- regdate — datetime
- comdate — datetime
- title — varchar(200)
- content — varchar(5000)
- comment — varchar(5000)
comment
- comment_no — INT — Primary key — NOT NULL
- mem_no — INT
- job — VARCHAR(20)
- mem_name — VARCHAR(30)
- comment — TEXT — EX
- regdate — DATETIME
- updatedate — DATETIME
- bod_no — INT
d_approval
- d_board_id — INT — Primary key — NOT NULL
- pass — varchar(20)
- member_name — varchar(20)
- member_no — varchar(20)
- areacode — INT
- member_name2 — varchar(20)
- member_no2 — varchar(20)
- regdate — date
- comdate — date
- title — varchar(200)
- content — varchar(5000)
- comment — varchar(5000) — archar(5000
daily_workstatus
- dw_id — INT — Primary key — NOT NULL
- member_no — INT
- check_in — TIME
- check_out — TIME
- work_hours — TIME
- date_id — INT
- is_late — INT
- overtime — TIME
dates
- date_id — int — Primary key — NOT NULL
- event_date — date
dept
- dept_no — INT — Primary key — NOT NULL
- dept — VARCHAR(20)
dept_board
- bod_no — INT — Primary key — NOT NULL
- dept_no — INT
- mem_no — INT
- title — VARCHAR(30)
- writer — VARCHAR(20)
- content — TEXT
- regdate — datetime
- updatedate — DATETime
- is_notice — INT
events
- event_id — int — Primary key — NOT NULL
- date_id — int
- member_no — int
- event_title — varchar(30)
- event_description — varchar(255)
files
- fno — INT — Primary key — NOT NULL
- mno — int — NOT NULL
- ogFile_name — varchar(300) — NOT NULL
- file_name — varchar(300) — NOT NULL
- file_path — varchar(500) — NOT NULL
- file_size — int — NOT NULL
- created_date — datetime — NOT NULL
job
- job_no — INT — Primary key — NOT NULL
- job — VARCHAR(20)
member
- mem_no — int — Primary key — NOT NULL
- mem_pw — varchar(200)
- mem_name — varchar(20)
- job — int
- birth — varchar(20)
- email — varchar(50)
- phone — varchar(20)
- dept_no — int
- hiredate — datetime — NOT NULL
- is_initial_login — tinyint(1)
v_approval
- v_board_id — INT — Primary key — NOT NULL
- pass — varchar(20)
- member_name — varchar(20)
- member_no — varchar(20)
- areacode — INT
- member_name2 — varchar(20)
- member_no2 — varchar(20)
- regdate — date
- comdate — date
- title — varchar(200)
- content — varchar(5000)
- comment — varchar(5000) — archar(5000