AorB
Tables (12)
adminuser
- admin_no — INT — Primary key — NOT NULL
- email — VARCHAR(100)
- pw — VARCHAR(100)
buyer
- buyer_no — INT — Primary key — NOT NULL
- product_no — INT — Foreign key → product.product_no — NOT NULL
- test_no — INT — Foreign key → product.test_no — NOT NULL
- user_no — INT — Foreign key → usersample.user_no — NOT NULL
- date — DATE
- page_type — VARCHAR(10)
pagecnt
- page_no — INT — Primary key — NOT NULL
- test_no — INT — Foreign key → test.test_no — NOT NULL
- cntA — INT
- cntB — INT
- date — DATE
product
- product_no — INT — Primary key — NOT NULL
- test_no — INT — Foreign key → test.test_no — NOT NULL
- product_name — VARCHAR(50)
- product_price — INT
- product_detail — VARCHAR(200)
- product_image — VARCHAR(100)
test
- test_no — INT — Primary key — NOT NULL
- admin_no — INT — Foreign key → adminuser.admin_no — NOT NULL
- test_title — VARCHAR(50)
- test_a — VARCHAR(50)
- test_b — VARCHAR(50)
- start — DATE
- end — DATE
- per_a — INT
- per_b — INT
- status — VARCHAR(50)
- url_a — VARCHAR(100)
- url_b — VARCHAR(100)
testattribute
- test_attribute_no — INT — Primary key — NOT NULL
- test_no — INT — Foreign key → test.test_no — NOT NULL
- page_type — VARCHAR(10)
- attribute_name — VARCHAR(50)
- attribute_type — VARCHAR(50)
- attribute_value — VARCHAR(50)
testdata
- data_no — INT — Primary key — NOT NULL
- url_no — INT — Foreign key → urlattribute.url_no — NOT NULL
- test_no — INT — Foreign key → urlattribute.test_no — NOT NULL
- user_no — INT — Foreign key → user.user_no — NOT NULL
- page_type — VARCHAR(10)
- date — DATE
- isJoined — BOOLEAN
- gender — VARCHAR(50)
- age — INT
urlattribute
- url_no — INT — Primary key — NOT NULL
- test_no — INT — Foreign key → test.test_no — NOT NULL
- url_name — VARCHAR(50)
user
- user_no — INT — Primary key — NOT NULL
- test_no — INT — Foreign key → test.test_no — NOT NULL
- session_id — VARCHAR(100)
- page_type — VARCHAR(10)
- date — DATE
userattribute
- user_attribute_no — INT — Primary key — NOT NULL
- user_no — INT — Foreign key → user.user_no — NOT NULL
- page_type — VARCHAR(10)
- attribute_name — VARCHAR(50)
- attribute_type — VARCHAR(50)
- attribute_value — VARCHAR(50)
usersample
- user_no — INT — Primary key — NOT NULL
- test_no — INT — Foreign key → test.test_no — NOT NULL
- email — VARCHAR(100)
- pw — VARCHAR(100)
- age — INT
- gender — VARCHAR(50)
- page_type — VARCHAR(10)
- join_date — DATE
- session_id — VARCHAR(100)
- birth — DATE