seocond
Tables (21)
ADDRESS_INFO
- Key (ADDR_SEQ) — BIGINT — Primary key — NOT NULL
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (POST_NO) — VARCHAR(10) — NOT NULL
- Field (ADDR_H) — VARCHAR(200) — NOT NULL
- Field (ADDR_D) — VARCHAR(200) — NOT NULL
- Field (DEFAULT_YN) — SMALLINT — NOT NULL
- Field (ADDR_NM) — VARCHAR(50) — NOT NULL
Untitled (ALARAM)
- Key (ALARM_SEQ) — BIGINT — Primary key — NOT NULL
- Field (SENT_DTM) — TIMESTAMP
- Field (ALARM_CONT) — VARCHAR(500)
- Key (CHAT_MSG_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (CHAT_ROOM_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (MEMBER_OAUTH)
- Key (MEMBER_OAUTH_SEQ) — BIGINT — Primary key — NOT NULL
- Field (PROVIDER) — ENUM
- Field (CONNECTED_DT) — DATE
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (BOOK_CLUB_BOARD)
- Key (BOOK_CLUB_BOARD_SEQ) — BIGINT — Primary key — NOT NULL
- Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (BOARD_TITLE) — VARCHAR(200)
- Field (BOARD_CONT) — TEXT
- Field (BOARD_IMG_URL) — VARCHAR(500)
- Field (BOARD_DELETED_YN) — BOOLEAN
- Field (BOARD_DELETED_DTM) — TIMESTAMP
- Key (PARENT_BOOK_CLUB_BOARD_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (BOOK_CLUB_SEQ2) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (BOOK_INFO_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
Untitled (BOOK_CLUB_MEMBER)
- Key (BOOK_CLUB_MEMBER_SEQ) — BIGINT — Primary key — NOT NULL
- Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (LEADER_YN) — BOOLEAN — NOT NULL
- Field (JOIN_ST) — ENUM
- Field (JOIN_ST_UPDATE_DTM) — TIMESTAMP
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (BOOK_CLUB_REQUEST)
- Key (BOOK_CLUB_REQUEST_SEQ) — BIGINT — Primary key — NOT NULL
- Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (REQUEST_CONT) — TEXT
- Field (REQUEST_ST) — ENUM — NOT NULL
- Field (REQUEST_DTM) — TIMESTAMP — NOT NULL
- Field (REQUEST_PROCESSED_DT) — DATE
- Key (REQUEST_MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (BOOK_CLUB_WISH)
- Key (BOOK_CLUB_WISH_SEQ) — BIGINT — Primary key — NOT NULL
- Key (BOOK_CLUB_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (BOOK_CLUB)
- Key (BOOK_CLUB_SEQ) — BIGINT — Primary key — NOT NULL
- Field (BOOK_CLUB_NAME) — VARCHAR(100) — NOT NULL
- Field (BOOK_CLUB_DESC) — TEXT
- Field (BOOK_CLUB_RG) — VARCHAR(50)
- Field (BOOK_CLUB_MAX_MEMBER) — INT
- Field (BOOK_CLUB_DELETED_DT) — DATE
- Field (BANNER_IMG_URL) — VARCHAR(500)
- Field (BOOK_CLUB_SCHEDULE) — VARCHAR(200)
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Field (UPD_DTM) — TIMESTAMP
- Key (BOOK_CLUB_LEADER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (NOTICE)
- Key (NOTICE_SEQ) — BIGINT — Primary key — NOT NULL
- Key (ADMIN_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (NOTICE_TITLE) — VARCHAR(200)
- Field (NOTICE_CONT) — TEXT
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Field (UPD_DTM) — TIMESTAMP
Untitled (LOGIN_INFO)
- Key (LOGIN_INFO_SEQ) — BIGINT — Primary key — NOT NULL
- Key (ADMIN_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (LOGIN_DTM) — TIMESTAMP
- Field (LOGIN_IP) — VARCHAR(45)
- Field (LOGOUT_DTM) — TIMESTAMP
Untitled (ADMIN)
- Key (ADMIN_SEQ) — BIGINT — Primary key — NOT NULL
- Field (ADMIN_LOGIN_ID) — VARCHAR(50) — NOT NULL
- Field (ADMIN_PASSWORD) — VARCHAR(255) — NOT NULL
Untitled (REPORT)
- Key (REPOST_SEQ) — BIGINT — Primary key — NOT NULL
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (REPORT_TITLE) — VARCHAR(200)
- Field (REPORT_CONT) — CONT
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Field (REPORT_IMG_URL) — VARCHAR(500)
Untitled (MEMBER_INFO)
- Key (MEMBER_SEQ) — BIGINT — Primary key — NOT NULL
- Field (LOGIN_ID) — VARCHAR(50) — NOT NULL
- Field (MEMBER_PWD) — VARCHAR(255) — NOT NULL
- Field (MEMBER_EMAIL) — VARCHAR(100) — NOT NULL
- Field (MEMBER_TEL_NO) — VARCHAR(20)
- Field (MEMBER_NICKNM) — VARCHAR(50) — NOT NULL
- Field (MEMBER_DELETED_DTM) — TIMESTAMP
- Field (MEMBER_LAST_LOGIN_DTM) — TIMESTAMP
- Field (MEMBER_ST) — ENUM — NOT NULL
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Field (UPD_DTM) — TIMESTAMP
Untitled (CHAT_MSG)
- Key (CHAT_MSG_SEQ) — BIGINT — Primary key — NOT NULL
- Key (CHAT_ROOM_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
- Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
- Field (CHAT_CONT) — TEXT
- Field (SENT_DTM) — TIMESTAMP
- Field (READ_YN) — BOOLEAN
Untitled (BOOK_IMAGE)
- Key (BOOK_IMG_SEQ) — BIGINT — Primary key — NOT NULL
- Field (IMG_URL) — VARCHAR(500) — NOT NULL
- Field (SORT_SEQ) — BIGININT
Untitled (SB_TRADE_INFO)
- Key (TRADE_SEQ) — BIGINT — Primary key — NOT NULL
- Key (MEMBER_SELLER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (SALE_TITLE) — VARCHAR(200) — NOT NULL
- Field (BOOK_ST) — ENUM — NOT NULL
- Field (SALE_CONT) — TEXT
- Field (SALE_PRICE) — INT — NOT NULL
- Field (BOOK_DELIVERY_COST) — INT
- Field (SALE_REGION_NM) — VARCHAR(100)
- Field (SALE_ST) — ENUM — NOT NULL
- Field (SALE_ST_DTM) — TIMESTAMP
- Field (VIEWS) — BIGINT — NOT NULL
- Field (WISH_CNT) — BIGINT — NOT NULL
- Field (BOOK_SALE_DTM) — TIMESTAMP
- Field (POST_NO) — VARCHAR(10) — NOT NULL
- Field (ADDR_H) — VARCHAR(200) — NOT NULL
- Field (ADDR_D) — VARCHAR(200) — NOT NULL
- Field (RECIPIENT_PH_NO) — VARCHAR(20) — NOT NULL
- Field (RECIPIENT_NM) — VARCHAR(50) — NOT NULL
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Field (UPD_DTM) — TIMESTAMP
- Field (PAYMENT_TYPE) — VARCHAR(20) — NOT NULL
- Key (BOOK_INFO_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
- Key (CATEGORY_SEQ) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
- Key (BOOK_IMG_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_BUYER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled2 (CHATROOM)
- Key (CHAT_ROOM_SEQ) — BIGINT — Primary key — NOT NULL
- Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (LAST_MSG_DTM) — TIMESTAMP
- Field (LAST_MSG) — TEXT
- Field (CRT_DTM) — TIMESTAMP
- Key (MEMBER_BUYER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled2 (SETTLEMENT)
- Key (SETTLEMENT_SEQ) — BIGINT — Primary key — NOT NULL
- Field (MEMBER_SELLER_SEQ) — BIGINT — NOT NULL
- Field (MEMBER_BUYER_SEQ) — BIGINT — NOT NULL
- Field (SALE_PRICE) — BIGINT — NOT NULL
- Field (SETTLEMENT_ST) — ENUMN — NOT NULL
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled2 (TRADE_WISH)
- Key (TRADE_WISH_SEQ) — BIGINT — Primary key — NOT NULL
- Key (TRADE_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_SEQ) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
Untitled2 (CATEGORY)
- Key (CATEGORY_SEQ) — BIGINT — Primary key — NOT NULL
- Field (CATEGORY_NM) — VARCHAR(50) — NOT NULL
- Field (CATEGORY_SORT_SEQ) — BIGINT
- Field (CRT_DTM) — TIMESTAMP — NOT NULL
- Field (UPD_DTM) — TIMESTAMP
Untitled2 (BOOK_INFO)
- Key (BOOK_INFO_SEQ) — BIGINT — Primary key — NOT NULL
- Field (ISBN) — VARCHAR(20) — NOT NULL
- Field (BOOK_TITLE) — VARCHRAR(200) — NOT NULL
- Field (BOOK_AUTHOR) — VARCHAR(100)
- Field (BOOK_PUBLISHER) — VARCHAR(100)
- Field (BOOK_IMG) — VARCHAR(500)
- Field (BOOK_ORG_PRICE) — INT