web
Tables (6)
CLOTHES
- id — BIGINT
- user_id — BIGINT
- cl_name — VARCHAR(255) — NOT NULL
- cl_type — VARCHAR(255)
- cl_color — VARCHAR(255)
- cl_season — VARCHAR(50)
- cl_time — DATETIME
- useYn — VARCHAR(3)
CODI
- id — BIGINT
- user_id — BIGINT
- clothes_id — BIGINT
- post_id — BIGINT
- co_codi — TEXT
- co_great — INT
- co_suggest — TEXT
- co_useYn — VARCHAR(3)
- useYn — VARCHAR(3)
- co_time — DATETIME
LAUNDRY
- id — BIGINT
- user_id — BIGINT
- clothes_id — BIGINT
- la_period — VARCHAR(50)
- la_time — DATETIME
- useYn — VARCHAR(3)
ORGANIZE
- id — BIGINT
- user_id — BIGINT
- clothes_id — BIGINT
- or_location — VARCHAR(100)
- useYn — VARCHAR(3)
POST
- id — BIGINT
- user_id — BIGINT
- clothes_id — BIGINT
- codi_id — BIGINT
- po_post — TEXT
- po_comment — TEXT — EX
- po_great — INT
USER
- id — BIGINT
- pwd — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- number — VARCHAR(20)
- post_addr — VARCHAR(100)
- addr — VARCHAR(100)
- addr_dtl — VARCHAR(100)
- birth — DATE
- writeDate — DATETIME
- useYn — VARCHAR(3)